2 Replies Latest reply: Jun 22, 2011 9:44 AM by Giovannone RSS

    Web macro to fit-to-screen

      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

        • Web macro to fit-to-screen
          m w

          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

            • Web macro to fit-to-screen

              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