Making munu-items not accessible.

[Guest]

Hello,

In my database i have an own-made menubar with a lot of menu items.
Depending on the user i wish to lock or unlock different items so that the
user can't use them.

At this moment i check the user AFTER he/she clicks on the menu.

(Something like in WORD, copy or paste isn't accessible if there is no text
selected)

 

[Marshall Barton]

In my database i have an own-made menubar with a lot of menu items.
Depending on the user i wish to lock or unlock different items so that the
user can't use them.

You need to traverse the CommandBar's Controls collection
(see Help).

Maybe something like:

CommandBars("yourbar").Controls("somecontrol").Enabled=False

Or, if you would prefer to make them invisible:

CommandBars("yourbar").Controls("somecontrol").Visible=False