Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disable scrolling when macros disabled
Hi,
When my wb is opened with macros disabled only one sheet is visible. I want to prevent the user from scrolling on this sheet, which i can do when macros are enabled but not when discabled. Is there a way to do this? (I tried setting the scroll area but this doesn't seem to take effect when macros are disabled). |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disable scrolling when macros disabled
not clear what exactly you need.... but would zoom page to about 70% then
freeze panes in the very bottom right hand conner. then zoom back to 100%? "anon" wrote: Hi, When my wb is opened with macros disabled only one sheet is visible. I want to prevent the user from scrolling on this sheet, which i can do when macros are enabled but not when discabled. Is there a way to do this? (I tried setting the scroll area but this doesn't seem to take effect when macros are disabled). |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disable scrolling when macros disabled
copy and paste the following in youre this workbook code
it will when u close it freeze panes and if u open with out macro's enable keep it freeze(unable to scroll) if macro's enabled it will be able to scroll Private Sub Workbook_BeforeClose(Cancel As Boolean) Range("v60").Select ActiveWindow.FreezePanes = True End Sub Private Sub Workbook_Open() ActiveWindow.FreezePanes = False End Sub |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disable scrolling when macros disabled
Render the workbook useless if users disable macros.
In a beforeclose event, hide all sheets but a dummy sheet with the message "By disabling macros you have made this workbook useless. Close and enable macros to continue." When users enable macros have workbook_open code that hides dummy sheet and makes your working sheet visible with the scrollarea set as you wish. Gord Dibben MS Excel MVP On Sat, 22 Mar 2008 08:48:44 -0700 (PDT), anon wrote: Hi, When my wb is opened with macros disabled only one sheet is visible. I want to prevent the user from scrolling on this sheet, which i can do when macros are enabled but not when discabled. Is there a way to do this? (I tried setting the scroll area but this doesn't seem to take effect when macros are disabled). |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Scrolling in Excel Spreadsheet suddenly DISABLED | Excel Discussion (Misc queries) | |||
Macros are disabled . . . and they shouldn't be | Excel Discussion (Misc queries) | |||
How to disable the scrolling in worksheet | Excel Programming | |||
Disabled Macros | Excel Programming | |||
macros disabled | Excel Programming |