restrict scrolling

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

Hi,
Check at the ScrollArea property of the Worksheet object in the online help.
Set it to the proper area each time a button is clicked.
Also to jump to a place in a sheet, use:
Application.Goto reference:=Worksheets("Sheet1").Range("A10"), scroll:=True

Finally, a note: the ScrollArea is reset to "" when the book open. SO , if
you want to start with an specific scrollarea when the book opens, you have
to set it in the Workbook_Open sub

--
Regards,
Sébastien


"KimR.Hammel" wrote:

> 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

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" <[email protected]> wrote in message
news:[email protected]...

>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