Grd,
That's the purpose of .ScrollArea; prevent users going to undesirable areas.
The setting is not saved with the file, so you set it each time on open.

NickHK

"Grd" wrote in message
...
Hi Dave,

Thanks for the response.

I know it is a strange request. I have some data down at the bottom that I
don't want the users (who are new to excel) to see. I don't want to hide
the
data for certain long-winded reasons that I won't get into. I would like
to
disable the zoom feature so they can't zoom out and see the data and then
get
confused why there is some data at the bottom.

Maybe I can delete the zoom button when my spreadsheet opens and recreate
it
when it closes. Would that be a possible way of doing it if disabling zoom
is
not an option?

Thanks
Sandra

"Dave Peterson" wrote:

I would think the best you could do is to reset the zoom whenever the
user
changes the selection.

But why would you want to?

There are lots of people who may need a larger zoom to see clearly.
Others may
like to see more on the screen with a smaller zoom.



Grd wrote:

Hi,

Is this possible to do?
I can't seem to figure it out.

Any help greatly appreciated.

Thanks

Sandra

--

Dave Peterson