Custom menu

[Ginny2222]

I have built a custom toolbar. 2 things I am having a problem with. Can I make the toolbar only available in a specific workbook. Secondly, I have a list of items which will change from time to time on a worksheet. Is it possible to have these linked to the menu as the captions on the menu items?

I hope the above makes sense !!!!

Thanks in advance.

rgs
Ginny

 

[smiler44]

Is this any good?

If ActiveWorkbook.Name <> ("nameofworkbook.xls") Then
Toolbars("nameofcustumtoolbar").Visible = False

if a user tries to make the toolbar visible then this can go at the beginning of any macros you do not want them to run

If ActiveWorkbook.Name <> ("nameofworkbook.xls") Then
MsgBox ("Sorry you are not authorised to run this macro")
Toolbars("nameoftoolbar").Visible = False
Exit Sub
End If

smiler44

 

[Ginny2222]

Hi Smiler44

I put that into the Personal Workbook and it's not bad. I then decided to code it rather than use Excel's facility for making menu's and this is much more satisfactory. I have solved both my problems this way.

Thanks for the suggestion.

Ginny