Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Locking components BUT Still allowing to change settings via VBA
Hi. I am relatively new but I am trying to lock/protect scroll bars etc
which I can do. However, I have code in VBA which I want to set the Max and Min etc but which does not work (error will occur) after the sheet is protected. I also can not set any specific cells sometimes also. Am not quite sure what I can do. I want it that it CAN NOT MOVE and also can not change scroll max and min but only through VBA once all sheets are protected. Thanks in advance! -- Stan |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Locking from data entry but allowing oulining to function? | Excel Discussion (Misc queries) | |||
Locking a spreadsheet, yet allowing sort | New Users to Excel | |||
Locking a spreadsheet and allowing hyperlinks and sort | New Users to Excel | |||
Locking a worksheet, but allowing user to add rows in a table | Excel Worksheet Functions | |||
locking text in a cell, but allowing new text to be added | New Users to Excel |