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