I have a spreadsheet that several users will have access to. I would like to password protect this but only so you are unable to unhide certain sheets. I know how to password protect the workbook but I don't want people having to type in passwords when they are logging in, plus, this would defeat the purpose I want to use it for. Is this possible to do?
Thanks
In the VBE you can set the visible properties of those worksheets to xlVeryHidden in which case they are invisible to the user.
Elegant Simplicity............. Not Always
Thanks for the info, I have never used VBE before but I have just been meesing with it and seem to have lost the worksheet I was trying to hide. I don't suppose you know how I get to view it again do you?this is why I shouldn't be left alone with a computer!
LOL............. There are 2 ways.. try this one first
1. Right click on a worksheet tab
2. Select the unhide option
I'm glad you find this funny haha, please don't mention other complicated programmes I haven't used before as I will for sure attempt it haha
I have tried that, no joy
This may be of use. When I right click and select 'view code'"my worksheet shows up there and the code is
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
End Sub
Good sign ...
Now find the properties window of the VBE.. usually to the left or you may have to switch it on --> F4
Scroll down the properties till you find Visible
Select it and small drop down arrow appears to the right
From the dropdown you can select Unhidden, Hdden or VeryHidden
If you select VeryHidden it disabled the first method of unhiding sheets
Thank you very much. It has worked a treat. And I now know how to hide the sheet
Glad to hear it
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks