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.


"ajmplanner" wrote in message
...
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.

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.


ajmplanner wrote:

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.

--

Dave Peterson

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

HTH,
Ryan--

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"Dave Peterson" wrote:

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.


ajmplanner wrote:

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.

--

Dave Peterson