MrExcel Publishing
Your One Stop for Excel Tips & Solutions

How do I hide sheets within a workbook


Posted by Barry Katcher on November 08, 2001 7:11 AM

I have a budget workbook with 20 different departments, each on its own sheet, with them all flowing to a consolidated sheet. I want to allow each department head to be able to input to his/her own sheet, and not to be able to input to, OR EVEN SEE, the sheets from other departments, since the data is confidential. Any suggestions?


Posted by Barrie Davidson on November 08, 2001 7:41 AM

You can make the sheets "Very Hidden" when you are in the Visual Basic Editor (access by ALT + F11). Select the sheet from the Project Explorer Window (usually found at the top left). At the Properties Window (usually found at the bottom left), change the Visible property from "-1 - xlSheetVisible" to "2 - xlSheetVeryHidden".

Hope this helps you out.

Barrie

PS - You're spelling your name wrong :-)Barrie Davidson

Posted by Barry Katcher on November 08, 2001 8:43 AM

Thanks, Barrie-Barree-Barry

Thanks again. I'm not yet very adept at VBA but I'll give it a try. Will this allow each person to only be able to access, view and input to their own department? If so, how do I password protect so they can't access the other departments?