Hi,
Put the macro in the workbook open event.
Mike
"timja" wrote:
Hello,
I recorded my macro (completed macro comes into a line chart), save it.
Closed the program. Upon opening the program the macro doesn't show
automatically. I have to manually open the macro.
What have I missed?
"Mike H" wrote:
Hi,
If you mean you want the maro to execute as soon as the workbook is opened
then:
Alt+F11 to open VB editor
Double click 'This Workbook'
From the drop downs on the right hand panel select 'Workbook" and in the
other dropdown select 'Open'.
Put your code in there
Private Sub Workbook_Open()
'do your stuff
End Sub
Mike
"timja" wrote:
Is it possible to have a recorded Macro appear as soon as the Excel document
is opened? If yes, how?