| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Running macro on open of workbook?
Thank you all for you help...
"Lime" wrote: Here is what I have but it is not working, Am i Missing something?? Private Sub workbook_Open() Sub addsheet() Sheets("Sheet2").Select Sheets.Add MsgBox ("Macro finished") "Bearacade" wrote: Put this in ThisWorkbook in VBA Private Sub Workbook_Open() Call whateveryourmacroiscalled() MsgBox ("Macro Finished") End Sub -- Bearacade ------------------------------------------------------------------------ Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016 View this thread: http://www.excelforum.com/showthread...hreadid=551938 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| macro not running on workbook open | Excel Programming | |||
| Running a macro in a open as read-o Workbook | Excel Programming | |||
| Running a macro in a open as read-o Workbook | Excel Programming | |||
| Running a macro in a open as read-o Workbook | Excel Programming | |||
| Application Error when running Macro on Workbook open | Excel Programming | |||
Threaded Mode
