Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am trying to protect to 2 worksheets upon work book open
Code: Private Sub Workbook_Open() Password = "1234" Sheets("MasterData").Visible = xlSheetVeryHidden Sheets("MasterData").Protect Password, True, True, True Sheets("Unassigned Requests").Protect Password, True, True, True End Sub This works fine and it protects the sheets. But 1. It protects the workbook also. When i open the excel it asks for a password, which i dont require and i am not able to remove it 2. When I supply the same password in the excel (Tools Protection UnProtect), it does not work. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Code to protect all the worksheets in a book | New Users to Excel | |||
work book sheets | Setting up and Configuration of Excel | |||
One cell to many cells (two different work book/sheets) | Excel Discussion (Misc queries) | |||
How do I repeat XML map in sheets of the same excel work book | Excel Discussion (Misc queries) | |||
Protecting a book protects too much?! | Excel Programming |