Determining Zoom Percentage (2000, SP-3)

Topic

New Reply

Could one of you tell me how, in a VBA macro, I can determine the screen zoom percentage. I am not interested in the print zoom, only the display? I have searched here and on a couple of other sites (Pearson’s for one) and can’t find what I am looking for. the MSExcel VBA help only addresses the print zoom….

Thanks in advance…

Reply | Quote

Replies

Hi Robbie,

Sub Macro1()
MsgBox ActiveWindow.Zoom
End Sub

If you want to find out those kind of things, it is always a good idea to use the Macro recorder.
Recording e.g. the change of your zoom from 100 to 75, the resulting code may give you an idea what the correct command could be.

Best regards

Wolf

Reply | Quote

Thanks Wolf, that did give me the command I needed. I swear that I tried that but I guess I did it wrong!!!!

Reply | Quote