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