Custom toolbar weirdness

[Atholl]

Hi All,

I have a custom toolbar associated with a workbook which works fine. If I want to modify it slightly by doing the alteration, deleting the currently attached toolbar and attaching the new modified one, this works fine until I save and reopen.
When I reopen, the changes have not been saved! If I repeat this process (modifying, etc.) and save again, it works. It seems I always have to make the modifications twice

By the way, I have a bit of code built in which deletes the custom toolbar from the application on exit (I don't know if this has anything to do with it):

Sub Workbook_BeforeClose(Cancel As Boolean)

Application.CommandBars("CPM_TOOL").Delete

End Sub

Any ideas to save me doing this all twice every time I make a small amendment?


Atholl

 

[Richie(UK)]

Hi A,

Why not create the toolbar in VBA? :wink:

 

[Atholl]

Because this is the only way I know how!


Atholl

 

[Richie(UK)]

Because this is the only way I know how!


Atholl

Are you interested in learning the VBA approach?

 

[Atholl]

I would like to learn this approach, but it may take too long, as I'm on a timescale!

I found that the problem I am having is indeed a bug known to microsoft:

http://support.microsoft.com/default.aspx?kbid=330345


I'll have to wait until Service Pack 3 is released


Atholl