Macro When Worksheet Opens

  • Thread starter Thread starter ajmplanner
  • Start date Start date
A

ajmplanner

I would like to have a macro in VB executed immdeiately when the worksheet
opens that will display a menu, rather than have the user click a command
button on the already opened worksheet to display that menu. Can this be
done? If so how? THanks in advance for any replies.
 
If you really mean "worksheet" then you could use the Worksheet_Activate
event with the macro being in the sheet code module.

But if you mean "workbook" then you would use the Workbook_Open event and
put the code in the ThisWorkbook code module.

Without more detail about the menu, that is about all I can tell you.
 
When the workbook (not worksheet) opens?

Use a procedure named Auto_Open in a General module.

Or use the Workbook_Open event inside the ThisWorkbook module.

But I'm not sure if this helps. I'm not sure what you mean by that menu stuff.

If you meant when a worksheet is activated (moving from a worksheet in the same
workbook in the same window), you can use a worksheet_Activate event in that
worksheet's module.
 
Back
Top