How to get macros to run atuomatically in Office 97

[Tsaico]

I have a table that I want to keep adding information to. I have a macro to use the form function to help me do it faster, but I am just wondering if there is anything that I can set so that this particular macro will run everytime my workbook is open.

 

[Whitecloak]

probably

worksheet.activate
or
workbook.open
or
workbook.sheetactivate ?

 

[WW]

name it AutoOpen

here's the list of 'special' macros in excel:

AutoExec the macro runs when Excel is opened
AutoExit the macro runs when you exit Excel
AutoOpen the macro runs when you open a worksheet
AutoNew the macro runs when you create a new worksheet
AutoClose the macro runs when you close the current worksheet

 

[Whitecloak]

Originally posted by: WW
name it AutoOpen

here's the list of 'special' macros in excel:

AutoExec the macro runs when Excel is opened
AutoExit the macro runs when you exit Excel
AutoOpen the macro runs when you open a worksheet
AutoNew the macro runs when you create a new worksheet
AutoClose the macro runs when you close the current worksheet

thanx for the info 🙂