Macro When Worksheet Opens

[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.

 

[JLGWhiz]

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.

 

[Dave Peterson]

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.

 

[ryguy7272]

Auto_Open; see example here:
http://www.contextures.com/xlfaqmac.html#AutoOpen

HTH,
Ryan--