MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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