View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bret Bret is offline
external usenet poster
 
Posts: 32
Default Custom Command Bar Erroring out when distributed

I've created a custom command menu bar for my Excel VBA app that appears on
right side of screen when application is opened.
It works great when I use it, the problem is when I send it (via Outlook) to
other users in my company it errors out.

Here is the Auto_Open code:
Sub Auto_Open()
Application.CommandBars("Formatting").Visible = False
Application.CommandBars("Standard").Visible = False
Application.CommandBars("Global").Visible = True
Application.CommandBars("Global").Enabled = True
application.CommandBars("GlobalComp").Position = msoBarRight
End Sub

Here is the error my users are getting:
€œrun time error-2147024809 (80070057)€- cant move focus to the control
because it is invisible, not enabled, or of a type that does not accept the
focus

When I debug the program on their workstation, I actually cant find my
"Global" command bar listed as one of the toolbar selections. Does the custom
command bar only exists on my workstation?

thanks in advance.