How to run a macro automatically when i open my excel spreadsheet

  • Thread starter Thread starter Guest
  • Start date Start date
Hi,

In the Project explorer, open the "Thisworkbook" module
In the Top left dropdown of the module code window, select "Workbook" iso
"Declaration".
The top right dropdown gives you all the events associated with this
workbook, and for wich
you can have a sub.

Choose the "Workbook_Open"
Et voila.

Regards,

Jean-Yves
 
Hi
in addition to use the Workbook_Open event you may rename your macro
Auto_Open()
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to make a spreadsheet as popup? 2
How to keep the Checkboxes selected by the user unchanged even after closing the userform 5
Hyperlink to open a common dialog on a msgbox 1
How to get a range of values into a combo placed on USERFORM? 3
How to Check a checkbox on spreadsheet from VB code 2
How to check output folder has been created in the network path?using VBA programming 5
Excel Excel spreadsheets opening at top instead of bottom. 4
Run Macro If Cell have "x" value 0

Back
Top