Create a toolbar that only shows for a specific workbook.

[traversd]

Hi,

Does anyone know how to creat a toolbar with a button (to activate a macro) on that will only display for a specific workbook and then remove it'self when that workbook is closed ?

Any help appreciated....

 

[Dave Hawley]

Hi

If it is a Custom toolbar then you will see the code for this here:
http://www.ozgrid.com/VBA/ExcelWorkbookEvents.htm

 

[traversd]

Thanks Dave,

That lot looks complicated and will take a while to work through but i expect it's just what I'm looking for !!

Thanks Dave.

 

[Dave Hawley]

Here is a much simplified version that does not hide all other toolbars. Your Custom Toolbar must be attached to your Workbook to use this.


Dim IsClosed As Boolean

Private Sub Workbook_Activate()
Application.CommandBars("MINE").Visible = True
End Sub


Private Sub Workbook_BeforeClose(Cancel As Boolean)
IsClosed = Not Cancel
End Sub


Private Sub Workbook_Deactivate()
If IsClosed = True Then
Application.CommandBars("MINE").Delete
Else
Application.CommandBars("MINE").Visible = False
End If
End Sub