Commandbar error on one machine

[JDK]

Hi -
I have created a custom commandbar for an application with about 15
users. When a user logs into the application, some code is run to
hide certain menu items depending on the users security group:

e.g.

if gstrUserSG="Admin" then

CommandBars("AppMenu").Controls("Administration").CommandBar.Controls(1).Visible=True
else

CommandBars("AppMenu").Controls("Administration").CommandBar.Controls(1).Visible=False
end if

where gstrUserSG is a global variable used to store the users security
group.

This works on all the users machines (about 15 in all) with the
exception of 1. On that one I get the error:

Method 'CommandBar' of object 'CommandBarPopup' failed

MS Office has been uninstalled and reinstalled ... and still this
remains. Any thoughts greatly appreciated.

 

[Hunter57]

Hi -
I have created a custom commandbar for an application with about 15
users. When a user logs into the application, some code is run to
hide certain menu items depending on the users security group:

e.g.

if gstrUserSG="Admin" then

CommandBars("AppMenu").Controls("Administration").CommandBar.Controls(1).Vi­sible=True
else

CommandBars("AppMenu").Controls("Administration").CommandBar.Controls(1).Vi­sible=False
end if

where gstrUserSG is a global variable used to store the users security
group.

This works on all the users machines (about 15 in all) with the
exception of 1. On that one I get the error:

Method 'CommandBar' of object 'CommandBarPopup' failed

MS Office has been uninstalled and reinstalled ... and still this
remains. Any thoughts greatly appreciated.

This is just a shot in the dark but . . .
Have you checked your references under Tools in your VBA editor?

Hunter57