Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello,
I've read various pages about locking ranges, protection, etc, but none of it seems to work across the board. From VB, I'm opening a workbook, and the entire thing should be locked. The user should be able to scroll and see everything, but they shouldn't be able to edit anything. I specify read only when I open it, and i call .Protect for the workbook, and as a test I do .Protect DrawingObjects:=True, Contents:=True, Scenarios:=True, UserInterfaceOnly:=True to protect the only sheet in the workbook. What ends up happening is part of the worksheet is protected, but not the entire worksheet. What am I doing wrong, and what needs to be done to do it right? Thanks, Jason |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Locked cells are still able to be selected with proper protection | Excel Discussion (Misc queries) | |||
Protection & Locked issue | Excel Discussion (Misc queries) | |||
locked out of my sheet for read only | Excel Worksheet Functions | |||
ADO: Read Excel file that is in use (locked) | Excel Programming | |||
setting Select (Un)Locked Cells in Worksheet Protection | Excel Programming |