Custom Menu
I would like to know how to trigger a custom menu every time a
worksheet (xyz.xls) is open. This xls spreadsheet is created every week and I can not figure out how to do that ? What I read is that I can put VBA code in the ThisWorkbook module but because this xls is generated from scratch every week I can not do that. Suggestions please.... Thanks Luis |
Custom Menu
Can you create a template workbook that can be used to generate that xyz.xls
workbook? If you can, then that template could contain the code for creating the custom menu. If you can't, then how about dumping the idea of using that workbook to create the custom menu and using an addin that does it instead. You can load the addin whenever you need it. For additions to the worksheet menu bar, I really like the way John Walkenbach does it in his menumaker workbook: http://j-walk.com/ss/excel/tips/tip53.htm Here's how I do it when I want a toolbar: http://www.contextures.com/xlToolbar02.html (from Debra Dalgleish's site) " wrote: I would like to know how to trigger a custom menu every time a worksheet (xyz.xls) is open. This xls spreadsheet is created every week and I can not figure out how to do that ? What I read is that I can put VBA code in the ThisWorkbook module but because this xls is generated from scratch every week I can not do that. Suggestions please.... Thanks Luis -- Dave Peterson |
All times are GMT +1. The time now is 11:10 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com