Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default error message Method €˜Add of object €˜CommandBar Controls fail?

When opening 2007 Excel I get the following message:

Run-time error €˜2147467259 (80004005)
Method €˜Add of object €˜CommandBar Controls failed

Program seems to work OK.
Is there something I need to do?

  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 5,939
Default error message Method €˜Add of object €˜CommandBar Controls fail?

2007 does not have a command bar. It uses the ribbon. Hard to add something
to a command bar that does not and can not exist. The code will need to be
changed if the command bar is required.
--
HTH...

Jim Thomlinson


"Sandy Pringle" wrote:

When opening 2007 Excel I get the following message:

Run-time error €˜2147467259 (80004005)
Method €˜Add of object €˜CommandBar Controls failed

Program seems to work OK.
Is there something I need to do?

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default error message Method ‘Add’ of object‘CommandBar Controls’ fail?

The commandbar code should still work. Any toolbars created will show up on the
Addins tab of the ribbon.

(I don't have a guess why the OP's problem occurs, though.)

Jim Thomlinson wrote:

2007 does not have a command bar. It uses the ribbon. Hard to add something
to a command bar that does not and can not exist. The code will need to be
changed if the command bar is required.
--
HTH...

Jim Thomlinson

"Sandy Pringle" wrote:

When opening 2007 Excel I get the following message:

Run-time error €˜2147467259 (80004005)
Method €˜Add of object €˜CommandBar Controls failed

Program seems to work OK.
Is there something I need to do?


--

Dave Peterson
Reply
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
runtime error 434, object does not support this method or property Janis Excel Discussion (Misc queries) 4 January 17th 08 04:10 PM
Charts.Add error '1004' Method 'Add' of object 'Sheets' failed Corey Charts and Charting in Excel 1 December 28th 06 02:15 PM
Intermittent Error - Method 'Add' of object 'HPageBreaks' failed Jamey Weare Excel Worksheet Functions 1 December 22nd 06 01:40 AM
runtime error 1004 method range of object '_global failed valdesd Excel Discussion (Misc queries) 2 October 6th 05 07:26 PM
Object doesn't support this property or method (Error 438) Kiran Excel Discussion (Misc queries) 1 July 12th 05 08:42 PM


All times are GMT +1. The time now is 03:04 PM.

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"