Hi,

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

Any help greatly appreciated.

Thanks

Sandra

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

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

You could disable the zoom icon. But don't forget to disable the zoom option
(under View). And lots of mice can be set to zoom on scroll.

And if you disable any/all of these, I could search the newsgroups and find how
to enable them.

I think I'd make it less obtrusive.

I'd put the data on another worksheet and hide that worksheet.

But this isn't really safe, either. But it may be less noticeable and keep
people from looking.

(Format|sheet|hide will hide the active sheet)

Grd wrote:

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


--

Dave Peterson

Disabling the zoom icon and menu seems to be the way to go.

Thanks again,


S



"Dave Peterson" wrote:

You could disable the zoom icon. But don't forget to disable the zoom option
(under View). And lots of mice can be set to zoom on scroll.

And if you disable any/all of these, I could search the newsgroups and find how
to enable them.

I think I'd make it less obtrusive.

I'd put the data on another worksheet and hide that worksheet.

But this isn't really safe, either. But it may be less noticeable and keep
people from looking.

(Format|sheet|hide will hide the active sheet)

Grd wrote:

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


--

Dave Peterson

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