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?




        • 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.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?