Ok, now I have a question about the Application.CommandBars("nameoftoolbar") function.
I have a toolbar with a menu with command buttons inside, sort of like this.
toolbar name is toolbar
A menu on the toolbar is file
on file is changepassword
quit
save
How do I make the changepassword field disabled?
I know this won't work:
Application.CommandBars("toolbar").Controls("changepassword").Enabled = false
This won't work either:
Application.CommandBars("file").Controls("changepassword").Enabled = false
Neither will this:
Application.CommandBars("toolbar").Controls("file").Controls("changepassword").Enabled = false
I need to know what will work.