ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Programming a macro to run on opening a workbook (https://www.excelbanter.com/excel-programming/343972-programming-macro-run-opening-workbook.html)

Mike

Programming a macro to run on opening a workbook
 
What is the code to program a macro to run when a workbook is opened?
Thanks

Ian

Programming a macro to run on opening a workbook
 
Call your macro auto_open (I think)

--
Ian
--
"mike" wrote in message
...
What is the code to program a macro to run when a workbook is opened?
Thanks




chijanzen

Programming a macro to run on opening a workbook
 
Hi ,mike

Workbook_Open event

Private Sub Workbook_Open()
'Your Marco
End Sub

--
http://www.vba.com.tw/plog/


"mike" wrote:

What is the code to program a macro to run when a workbook is opened?
Thanks


Kaak[_41_]

Programming a macro to run on opening a workbook
 

In de code of ThisWorkbook there are standard macro's like

Private Sub Workbook_Open()

'Call testMacro

End Su

--
Kaa
-----------------------------------------------------------------------
Kaak's Profile: http://www.excelforum.com/member.php...nfo&userid=751
View this thread: http://www.excelforum.com/showthread.php?threadid=47974



All times are GMT +1. The time now is 07:23 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com