Kim, something like this


Worksheets(1).ScrollArea = ""

'your macro


Worksheets(1).ScrollArea = "a1:h25"


--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003


"KimR.Hammel" wrote in message
...

I have a series of control buttons that navigate the user around a given
worksheet. To do so effectively, I need to restrict scrolling to a given
range after pressing each button. Upon pressing the next button, the
scrolling restriction needs to be turned off first, then run macro, then
turn
on new scrolling range restriction. Is this possible?
Thanks,
--Kim