Macro When Worksheet Opens
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. |
Macro When Worksheet Opens
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. |
Macro When Worksheet Opens
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 |
Macro When Worksheet Opens
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 |
All times are GMT +1. The time now is 08:34 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com