2 Replies Latest reply: Jun 21, 2011 3:13 AM by Chrisz Harms RSS

    running a Macro after reload

      Dear

       

      I would like to make an image from my worksheet

       

      I made a macro and after connecting it to a button object it works fine.

      what i want is that the macro runs straight after the reload is there a away i think i am missing something.

       

      thanks in advance

       

       

      the macro looks like this

      sub Image
      ActiveDocument.Sheets("Main").ExportBitmapToFile "d:\Dashboard.jpg"

      ActiveDocument.Save
      msgbox("There should be a picture!!!")
      end sub