Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Auto New macros?
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Auto New macros?
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 -- Regards, Tom Ogilvy "Christine" wrote in 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Auto New macros?
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 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto open macros in Excel | Excel Programming | |||
creating macros to auto fill cells | Excel Programming | |||
Auto run macros when opening CSV files | Excel Programming | |||
Auto load macros | Excel Programming |