Need Help - Want To Lock Excel Screen
Posted by Klaus on February 20, 2000 9:17 AM
HELP!
How can I lock an Excel Page so the user can NOT scroll
the page beyond what is visble? ... Thank You Klaus
Posted by Ivan Moala on February 20, 2000 6:55 PM
Klaus
Try;
Activesheet.scrollarea="A1:L21"
or what ever the area you want to lock;
Note: you set it from a macro...BUT you will
need to run this macro everytime when loading
to lock it.
Ivan
Posted by Klaus on February 21, 2000 8:45 AM
Re: Need Help - Ivan where do I put that formula?
Posted by Mark on February 22, 2000 11:19 AM
Re: Need Help - Ivan where do I put that formula?
Klaus
It can go in a macro that runs when the file is opened:
'StartUp Macro
'Executes automatically when the program opens.
Sub Auto_Open()
ActiveSheet.ScrollArea = "A1:L21"
End Sub
Then, when you later want to mod the worksheet run
'Remove Scroll Lock Macro
Sub Undoit()
ActiveSheet.ScrollArea = All
End Sub
Mark
Posted by Klaus on February 22, 2000 4:07 PM
Re: Need Help - Thank You Mark
