Disable commands in menu bar on startup

[akphidelt]

Hi, im running in to a little problem that I can't find a solution for.

I have built a custom menu bar that has the items that I want for my
application.

However, I want some of the items to be disabled whenever the application
starts up and enabled when a user enters the correct password information.
For some reason I can't figure out how to disable them at startup. I can do
it through the Immediate Window when testing. Here is an example

Application.CommandBars("POD").Controls("Reports").Enabled = False

Now that works and disables the Reports command but then when someone types
in the correct password and enables it the command remains enabled on the
next startup.

Does anyone have an idea on how to do this?

 

[Rick Brandt]

Hi, im running in to a little problem that I can't find a solution
for.

I have built a custom menu bar that has the items that I want for my
application.

However, I want some of the items to be disabled whenever the
application starts up and enabled when a user enters the correct
password information. For some reason I can't figure out how to
disable them at startup. I can do it through the Immediate Window
when testing. Here is an example

Application.CommandBars("POD").Controls("Reports").Enabled = False

Now that works and disables the Reports command but then when someone
types in the correct password and enables it the command remains
enabled on the next startup.

Does anyone have an idea on how to do this?

You have to disable it on startup every time and then decide when to enable
them (every time).

 

[akphidelt]

Yea, but how do I disable them on startup every time? I know how to hide the
entire menu bar but how do you disable the actual menu bar control on startup.

 

[Rick Brandt]

Yea, but how do I disable them on startup every time? I know how to
hide the entire menu bar but how do you disable the actual menu bar
control on startup.

With the same code that you used in the immediate window. Call that from
the AutoExec macro or else run that code in the Open or Load event of
whatever form you display at startup.

 

[akphidelt]

Touche my friend, touche!

Thanks a bunch

With the same code that you used in the immediate window. Call that from
the AutoExec macro or else run that code in the Open or Load event of
whatever form you display at startup.