ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Problem with workbook on_open event (https://www.excelbanter.com/excel-programming/441042-problem-workbook-on_open-event.html)

headly

Problem with workbook on_open event
 
I have a call to an addtoolbar() sub in my workbook on_open event. When i
first open the workbook, no toolbar added; if i close and reopen the workbook
the toolbar appears.

Gary Brown[_6_]

Problem with workbook on_open event
 
is your code a toggle? ie: if toolbar exists, get rid of it, if toolbar does
not exist, create it? That would explain what you described (without seeing
the actual code).
--
Hope this helps.
If it does, please click the Yes button.
Thanks in advance for your feedback.
Gary Brown



"headly" wrote:

I have a call to an addtoolbar() sub in my workbook on_open event. When i
first open the workbook, no toolbar added; if i close and reopen the workbook
the toolbar appears.



All times are GMT +1. The time now is 11:46 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com