Macro path follows the "SaveAs" file
When I do a SaveAs in a macro the toolbar button and the Menu item pointers
follow the new workbook. How do I anchor it so that the pointers will stay with the original workbook. BTW all previous help worked out very well, and I thank you. |
Macro path follows the "SaveAs" file
Your life will become much simpler if you include code to create the toolbar
when the workbook is opened and include code to destroy the toolbar when the workbook is closed. 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) OlieH wrote: When I do a SaveAs in a macro the toolbar button and the Menu item pointers follow the new workbook. How do I anchor it so that the pointers will stay with the original workbook. BTW all previous help worked out very well, and I thank you. -- Dave Peterson |
All times are GMT +1. The time now is 03:11 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com