use the workbook_ Open() event.
Autorun macro
Private Sub Workbook_Open()
your code
End Sub
-----Original Message-----
Excel Help says "Automatic macros, such as Auto_Open, are
designed to run when you start Excel. For more
information
about these macros, see Microsoft Visual Basic Help."
When I look in VB Help, however, I can't find any
reference to automatic macros.
What I need is the code for a macro to run automatically
whenever a user creates a new workbook based on my
template. The template is protected so the user can only
enter data in specific cells.
I presently have the following macro:
Sub Auto_New()
With ActiveWindow
.DisplayHeadings = False
.DisplayHorizontalScrollBar = False
.DisplayVerticalScrollBar = False
.DisplayWorkbookTabs = False
End With
End Sub
The macro will not run unless you specifically select
Tools, Macro, Run... etc., which obviously defeats the
point!
Can someone give me a really quick response?
Cheers,
Christine
.