"D.Parker" wrote:

Is there a way to change the size of the Excel workbook window such that a
user will not be able to scroll up or down for a given worksheet within the
workbook.

The only scrolling information I find in J. Walkenbach's book is relative to
userforms.

Thank you in advance for your assistance.

Kind regards,

Darryl

Is there a question here?

See VBA help on ScrollArea

Note: scrollarea won't stick between sessions so must be reset each time
the workbook is opened.


Gord Dibben MS Excel MVP

On Mon, 10 May 2010 15:02:01 -0700, John in CA <John in
wrote:



"D.Parker" wrote:

Is there a way to change the size of the Excel workbook window such that a
user will not be able to scroll up or down for a given worksheet within the
workbook.

The only scrolling information I find in J. Walkenbach's book is relative to
userforms.

Thank you in advance for your assistance.

Kind regards,

Darryl