Hide your excel sheet sheets-trick

 

Sometime we don't to share Data in Excel Sheets while forwarding Excel Files to someone, now what should we have to do for permanent hide. 

Here’s what I mean.

Let’s say I have a workbook with a sheet containing top secret data.

.I can go to the Visual Basic Editor (by pressing Alt+F11) and set the Visible property of the sheet to be xlSheetVeryHidden.

.This property not only hides my top secret sheet, but prevents anyone from manually unhiding it using the user interface.

.For extra protection, I also set a Protect Workbook password.

This should stop anyone from going into the VBE and resetting the visible property of my top secret sheet.

.Ok feel comfortable that your secreted data is protected & save and close the file.

 

 

Replies (4)

Keep sharing :)

Mukesh, unfortunately the images in your post is not visible. Can you please attach the details in Excel sheet or in a word document?

 

Regards

Sathish

I did it , how to retrive, unable to retrive message is appearing

pl help

Yes this is a good trick thaks you for sharing!

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Company
20 November 2026
Charted Accountant

Cothas Coffee Co.

Bengaluru

CA

View Details
Company
Featured ARTICLESHIP 18 November 2026
Articles

Saini Pati Shah & Co LLP, Chartered Accountants

Mumbai

CA Foundation

View Details
Company
Featured 07 November 2026
Paid Assisstant

DPV & Associates

Chennai

CA Inter

View Details
Company
28 October 2026
Assistant Director/ Associate Director-Finance & Accounting

Krea University

Chennai

CA

View Details
Company
16 November 2026
Indirect Tax Associate

Sekhri Kanodia & Associates

Mumbai

B.Com

View Details
Company
12 November 2026
Auditor

Oz Taxation

Vijayawada

Graduate (Any)

View Details
Company
ARTICLESHIP 14 November 2026
Articleship Assistant

B Thejas and Associates

Bengaluru

CA Foundation

View Details
Company
13 November 2026
Accountant

New Mobile India

Muzaffarpur

B.Com

View Details