Macros

Posted by Terence Bowen on July 24, 2001 6:48 AM

Hi Everyone

Can anyone help. I want to be able to run a Macro as soon as i enter Excel but I do not know how to do it.
Can anyone help me?

Thanks

Terry

Posted by Sean Tobin on July 24, 2001 10:57 AM

Right click on the Worksheet tab and click "View Code" This will open up the VB editor. View | Project Explorer. This will open a window on the left. Find on the left where it says "This Workbook" and double-click. This will open code editor. On the right drop-down in the editor, make sure it says "Open" Paste your code in that editor and save.

Sean