3 Replies Latest reply: May 4, 2009 9:51 PM by HECTOR GARCIA RSS

    zoom macro not working after upgrade from 7.5 to 8.5

    HECTOR GARCIA

      guys , after our recent upgrade from 7.5 to 8.5 following this simple but very appreciated by my users , stopped working

      ===============================================================================

       

       

      sub Zomm
      set mysheet=ActiveDocument.ActiveSheet
      set sp=mysheet.GetProperties
      set v= ActiveDocument.Variables("varZoom")
      var=v.GetContent.string/100
      sp.ZoomFactor=var
      mysheet.SetProperties sp
      ActiveDocument.ActiveSheet.ApplyZoomToAllSheets
      end sub

      ===================================================================

      any ideas will be appreciated

      Hector