Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Stop Scrolling
|
|
|
The UK's most regular Training information: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Stop Scrolling
Resolved · Low Priority · Version 2007
Reply Mon 30 Jan 2012, 12:22Delegate Elvin said...
Elvin has attended:
Excel VBA Intro Intermediate course
Stop Scrolling
Hi
I need to prevent users from scrolling in each worksheet of the workbook. I have tried teh followign but it does not work. Are you able to hep ?
Private Sub Worksheet_Activate()
Worksheets(1).ScrollArea = "a1:m34"
End Sub
Thanks
Elvin
For upcoming training course dates see: Pricing & availability
RE: Stop Scrolling
Hi Elvin
Your example does work but you have to activate Sheet1 first. Try clicking into Sheet2 then back into Sheet1.
Another place to add the code to is ThisWorkbook
(Double click ThisWorkbook, change from General to Workbook, Open)
Private Sub Workbook_Open()
Worksheets(1).ScrollArea = "a1:m34"
End Sub
Remember to save as a macro enabled workbook when finished or a 97-2003 format.
hope that helps
Cheers
Doug
Best STL
Mon 6 Feb 2012: Automatically marked as resolved.
|