View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default how to disable zoom in excel with vba

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