Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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