View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
anon anon is offline
external usenet poster
 
Posts: 77
Default 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).