how do i make macros execute automatically when i open my excel file?
thx

Put them in the Workbook Open Event Handler or refrence them there
to get to the workbook Code window right click on the image next to the File Menu item and Choose View Code. or Double Click on thisworkbook from the code editor menu and select workbook and open from the dropdown lists at the top of the screen.

Hope this helps

David

This also works....as I asked the same question a couple of weeks ago and got this anser from a different member:

In the Project window of the VBA window, double-click This Workbook.

Add the following:

Private Sub Workbook_Open()
Call Macro1' Or whatever your macro name is
End Sub



Melinda