Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Losing Cell Protection When Saving Workbook
Excel 2003. I programmatically protect each sheet in a workbook as I
programmatically create the sheets. Moreover, I enable only the unlocked cells in the sheets to be selected. I use: WkSh.Protect WkSh.EnableSelection = xlUnlockedCells When I put breakpoints in while debugging I find that the protection is working as expected (the sheet is protected and I can only select unlocked cells). When I am finished creating all the sheets, I then programmatically protect the whole work book as: WbNew.Protect When I check the sheets after this operation, they still behave as desired. HOWEVER, when I save the workbook using: WbNew.Close SaveChanges:=True and then open the workbook, I find the workbook protected (as expected), the sheets protected (as expected), but I can select the locked cells in the sheets What could be causing this? Thanks for the help. -- Dr. Doug Pruiett Good News Jail & Prison Ministry www.goodnewsjail.org |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How copy cell workbook to workbook? | Excel Discussion (Misc queries) | |||
How do I copy a cell + it's formula from one workbook to another? | Excel Discussion (Misc queries) | |||
copying cell names | Excel Discussion (Misc queries) | |||
Possible Lookup Table | Excel Worksheet Functions | |||
Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions |