MenuBar Question

J

Joe Williams

I have an app with a custom menu bar. Is there any way to programatically
"dim" options that are not valid or that a user should not access?

For instance, i have a form that only certain users can open based on thier
group membership. My main navigation tool is a custom menu bar. I would like
to be able to "dim" or gray out the option to open this form if the user is
not a member of a particular group.

Can it be done?

Thanks

Joe
 
R

Rick Brandt

Joe Williams said:
I have an app with a custom menu bar. Is there any way to programatically "dim"
options that are not valid or that a user should not access?

For instance, i have a form that only certain users can open based on thier
group membership. My main navigation tool is a custom menu bar. I would like
to be able to "dim" or gray out the option to open this form if the user is
not a member of a particular group.

Can it be done?

The following will disable the first menu item in a menu bar.

Dim Mnu as Object
Set Mnu = CommandBars("MenuName")
Mnu.Controls(1).Enabled = False
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top