Making munu-items not accessible.

  • Thread starter Thread starter Guest
  • Start date Start date
G

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)
 
Stefan said:
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.
Click to expand...


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
 
Back
Top