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).