Disable zoom

A

Al

Hi,
Is there a bit of programming I can add to this to disable
any further zoom once a WB opens at 100%?

Sub Zoom_freeze()
ActiveWindow.Zoom = 100
End Sub

Thanks
 
F

Frank Kabel

Hi
don't think this is possible. You may add some code to the
sheetactivate event to set the zoom always to 100% again then enabling
a sheet
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Setting a default zoom in Infopath 0
Cannot do anything after zooming - Publisher Lite on Mac 0
Macro to change column width and active window zoom as columns areselected 0
worksheet change question 1
Word doc won't center at 100% 5
Tab Code Retrieve a Value 3
Already Zoomed Out as Far as Possible 0
vba code to get an duse the value from a particular cell 3

Top