LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
custom command Ross in Oz[_2_] Excel Discussion (Misc queries) 0 February 18th 10 11:52 AM
Data Validation Not Erroring with List OyBouTJ Excel Worksheet Functions 2 June 4th 08 06:33 AM
Custom Command Bars barrowhill Excel Discussion (Misc queries) 1 March 29th 08 02:19 PM
Excel Erroring on Close Denny Behnfeldt Excel Programming 1 February 22nd 05 02:19 AM
custom command bar question rju[_3_] Excel Programming 4 July 7th 04 04:53 AM


All times are GMT +1. The time now is 12:00 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"