LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 19
Default Code to protect sheets, protects work book also?

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Code to protect all the worksheets in a book bill_ball New Users to Excel 1 June 10th 10 08:06 AM
work book sheets kathy Setting up and Configuration of Excel 1 April 23rd 09 11:46 PM
One cell to many cells (two different work book/sheets) Shek5150 Excel Discussion (Misc queries) 7 August 29th 08 01:10 PM
How do I repeat XML map in sheets of the same excel work book Tooty Excel Discussion (Misc queries) 0 March 20th 08 11:10 PM
Protecting a book protects too much?! StargateFanFromWork Excel Programming 2 July 6th 04 12:52 PM


All times are GMT +1. The time now is 02:17 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"