running a Macro after reload

[#1]

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

[kaushalview · Accepted solution]

Hi,

go to

Setting-->Document Property-->Trigger-->Select On Post Reload-->Click on Add Button on right side

then add Action as Run Macro --> MacroName

Regrads

Kaushal mehta

[#3]

thank you very much

cheers

Chrisz