Disable zooming in excel

[teranprasanna]

Hi All,

Can we disable zooming in excel using VBA?


Thanks!

[HansV]

Is this for yourself, or do you want to prevent all users of your workbooks from zooming in?
What if someone has limited eyesight and needs to enlarge the cells in order to view them?

[teranprasanna]

Thanks Hans..

Purpose is to limit specify cell area for the viewer. Example I wanted to show only the columns A to M, I blocked scrolling using VBA.. But if someone can zoom out, they can see columns beyond M.. this is the reason behind this query.

Can we achieve above purpose using any other way in VBA?

Regards,
Teran

[HansV]

You could hide the columns and rows that you don't want the users to see.
For example:
- Press F5 to display the Go To dialog.
- Enter N:XFD in the box.
- Press Enter or click OK.
- Right-click any of the selected column headers.
- Select Hide from the context menu.
Everything to the right of column M will be hidden:

S0576.png

[teranprasanna]

Thanks, Hans..