Custom Toolbar Manipluation

[Guanjin Peter]

I created a custom toolbar named "sheetScroll"

can I manipulate in a way that it'll only open for this workbook (sample.xls) and not other workbooks?

 

[AlexM]

You can change .Visible property of your toolbar in Workbook_Activate and Workbook_Deactivate events and toolbar will be shown only for your workbook.

 

[DonkeyOte]

Yes you should be able to put in an Open & Close event on the workbook in question to load / unload the toolbar... where name = sheetScroll (may not need add-in code depends on how you have compiled things I guess)

Private Sub Workbook_Open()
AddIns("name").Installed = True
Application.CommandBars("name").Visible = True
End Sub

and close

Private Sub Workbook_BeforeClose(Cancel As Boolean)
AddIns("name").Installed = False
Application.CommandBars("name").Visible = False
End Sub

 

[Guanjin Peter]

just an additonal question, will the toolbar be there if the excel file is transferred to another pc?

 

[DonkeyOte]

you would need to attach the toolbar to the file before distributing (via View -> Toolbars -> Customise)