Auto New macros?

C

Christine

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
 
T

Tom Ogilvy

Put you macro in the Workbook_Open event and you can restrict it to creation
with code like

if thisworkbook.path = "" then
' the workbook has just been created

End if

before a workbook is saved, it doesn't have a path, so this would indicate
it was just created with your template.

http://www.cpearson.com/excel/events.htm
 
F

Frank Stone

use the workbook_ Open() event.
Autorun macro
Private Sub Workbook_Open()
your code
End Sub
 
Top