Web macro to fit-to-screen

[#1]

Hi everybody,

is there any way to create a macro to fit a page to screen resolution when viewing on a browser without IE-plugin?

Thanks!

Giovanni

[m_woolf]

Have you tried:

Sub ZoomToFit

rem ** fit active sheet to window and apply same zoom to all sheets **
ActiveDocument.ActiveSheet.FitZoomToWindow
' ActiveDocument.GetApplication.WaitforIdle
' ActiveDocument.ActiveSheet.ApplyZoomToAllSheets
End Sub

[#3]

i've already tried but it doesn't work without IE plugin.

i think there are such restriction to macro utilisation, because the GoToSheet and many others still work both via client and browser (without IE-plugin).

any other suggestion?

G