Running a macro/code when Excel starts.. 1

simmantix · May 8, 2003

Dear all,

I wish to run a piece of VBA code every time Excel starts..

E.g. - objExcel()_OnStart

CODE

I know this is the incorrect syntax/form/etc, anyone got any better ideas?? All I want to do is delete some values and formatting every time the program comes up..

Thanks

kayah · May 8, 2003

Put these lines on the "ThisWorkbook" code sheet (not as a module):

Private Sub Workbook_Open()
CODE
End Sub

simmantix · May 8, 2003

Thankyou..

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Running a macro/code when Excel starts.. 1

simmantix

Nuclear

kayah

Structural

simmantix

Nuclear

Similar threads

Part and Inventory Search

Sponsor