Need Help:
I am trying to assign a custom toolbar to only one
workbook. The custom toolbar consists of several buttons each of which has a
macros assigned. The macros are such that they only can be used in the one
workbook. I CAN get the toolbar assigned to the workbook I want, but, the
problem is that the toolbar is also assigned to every other existing
workbook???


Any thoughts would be appreciated,
ken

Ken, the absolute best way to do this is to build the toolbar using VBA.
http://vbaexpress.com/kb/getarticle.php?kb_id=427

************
Anne Troy
www.OfficeArticles.com

"Ken Soenen" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Need Help:
> I am trying to assign a custom toolbar to only one
> workbook. The custom toolbar consists of several buttons each of which has
> a macros assigned. The macros are such that they only can be used in the
> one workbook. I CAN get the toolbar assigned to the workbook I want, but,
> the problem is that the toolbar is also assigned to every other existing
> workbook???
>
>
> Any thoughts would be appreciated,
> ken
>

One way:

After attaching the toolbar to your workbook. Put these macros in your
ThisWorkbook code module:

Private Sub Workbook_BeforeClose(Cancel As Boolean)
On Error Resume Next
Application.CommandBars("Custom 1").Delete
On Error GoTo 0
End Sub

Private Sub Workbook_Activate()
On Error Resume Next
With Application.CommandBars("Custom 1")
.Enabled = True
.Visible = True
End With
On Error GoTo 0
End Sub

Private Sub Workbook_Deactivate()
On Error Resume Next
With Application.CommandBars("Custom 1")
.Enabled = False
.Visible = False
End With
On Error GoTo 0
End Sub


In article <(E-Mail Removed)>,
"Ken Soenen" <(E-Mail Removed)> wrote:

> Need Help:
> I am trying to assign a custom toolbar to only one
> workbook. The custom toolbar consists of several buttons each of which has a
> macros assigned. The macros are such that they only can be used in the one
> workbook. I CAN get the toolbar assigned to the workbook I want, but, the
> problem is that the toolbar is also assigned to every other existing
> workbook???
>
>
> Any thoughts would be appreciated,
> ken

That article doesn't seem to have very much to do with the OP's
question. It's an article about how to add a menu item to the menu bar.
Once the item is added, it's available to all open workbooks.

The OP asked about configuring a custom toolbar so that it was only
available to a single workbook.

There's absolutely no need for the toolbar to be built using VBA. While
I tend to build my toolbars that way, there are some disadvantages to
doing so.

In article <#WIbXI$(E-Mail Removed)>,
"Anne Troy" <(E-Mail Removed)> wrote:

> Ken, the absolute best way to do this is to build the toolbar using VBA.
> http://vbaexpress.com/kb/getarticle.php?kb_id=427
>
> ************
> Anne Troy
> www.OfficeArticles.com
>
> "Ken Soenen" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> > Need Help:
> > I am trying to assign a custom toolbar to only one
> > workbook. The custom toolbar consists of several buttons each of which has
> > a macros assigned. The macros are such that they only can be used in the
> > one workbook. I CAN get the toolbar assigned to the workbook I want, but,
> > the problem is that the toolbar is also assigned to every other existing
> > workbook???
> >
> >
> > Any thoughts would be appreciated,
> > ken
> >