Hide and protect unhide of Exel worksheet

[flaviooooo]

Hey,

I have a excel workbook with 4 sheets. 3 sheets are calculated using data on sheet4, which contains private info.

Now we would like to hide the private sheet, and protect it so that unauthorized people can not unhide it.

The sheet needs to exist, because these people need to make calculations on the other sheets, using sheet4...

Hope you know what I mean...

Thanks

 

[BlueHorizon]

Hi flavioooo,
Place your cursor in the sheet to be hidden. Click on Format | Sheet | Hide. This hides the worksheet you don't want anyone to see. Then protect the workbook by clicking Tools | Protection | Protect Workbook. Select both Structure and Windows in popup. That should do it!

Good luck,
BlueHorizon

 

[SkipVought]

flaviooooo,

There are 2 kinds of hidden sheets available in Excel -- hidden and VERY hidden.

Hidden sheets can be unhidden from the menu with or without a password.

Very Hidden sheets can only be hidden and unhidden from VBA.



Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com

 

[flaviooooo]

It works, but the problem is...

the unauthorized people can still get to the data by simply using =sheet4!a1 etc...

By the way, my collegues are telling me that password protection in excel isn't secure by a long shot, so I'll probably have to create an Access database and a MDE file to be realy sure...


Thanks for the help though!