enable / disable submenu items

  • Thread starter Thread starter Wes Peters
  • Start date Start date
W

Wes Peters

I can not find any documentation on how to enable or disable submenu items
programatically.

I have a dropdown menu called Administration and under it are five
selections. I want to be able to programatically enable or disable the
selections based on a users login. The closest I can get is:

CommandBars("MainBar").Controls(1).Enabled = False

but that disables the whole dropdown menu. I can't find how to reference
the properties of the individual menu selections.

Thanks,
Wes
 
Hi Wes,

The reason you did not find any documention is because you were looking in the wrong place. You can
find this topic under:
1-800-ASK-JEFF

You're very close on your attempt.
What you need to do is "walk-down" the command bars controls collection.

Here is an example:
 
Oops, hit the Send button too soon!

Here is the example:
CommandBars("SwitchboardMenu").Controls("Tools").Controls("Administration").Enabled = False

The menu bar is SwitchboardMenu.
Under the Tools menu on the SwitchboardMenu I am disabling the Administration option.

Your example would be something close to this:

CommandBars("MainBar").Controls(1).Controls("WhateverOptionHere).Enabled = False
 
Thanks Jeff!

That does the trick. I assume that if need be you could ".Controls(x)" as
deeply as you have menus nested.

Thanks again for your help.
Wes


Jeff Conrad said:
Oops, hit the Send button too soon!

Here is the example:
Click to expand...
CommandBars("SwitchboardMenu").Controls("Tools").Controls("Administration").
Enabled = False
 
You're welcome Wes, glad to help.
Yes, you can continue as far down the menu structure as you need to go using the same syntax.
 
Back
Top