| 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 | |||
Threaded Mode
