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
10 November 2026
Direct Tax Manager

CAAQ CONSULTANCY PVT LTD

New Delhi

CA Final

View Details
Company
ARTICLESHIP 23 October 2026
CA Articleship / Article Assistant

M N Rao & Associates LLP

Vijayawada

CA Inter

View Details
Company
Featured 27 October 2026
semi-qualified CA

Saini Pati Shah & Co LLP, Chartered Accountants

Mumbai

CA Final

View Details
Company
ARTICLESHIP 07 November 2026
Article Assisstant

DPV & Associates

Chennai

CA Inter

View Details
Company
19 October 2026
Accountant

Jari Saree Center

New Delhi

Others

View Details
Company
ARTICLESHIP 25 October 2026
Article Intern (CA Articleship)

Arpan Bohra & Co

Hyderabad

CA Inter

View Details
Company
ARTICLESHIP 29 October 2026
Article Assistant (CA Inter / CMA Inter) - Thrissur

Varma Raja & Associates

Thrissur

CA Inter

View Details
Company
19 October 2026
Accountants/Articles (Freshers/Experienced)

ADY & CO.

New Delhi

Graduate (Any)

View Details