Take your code out of Workbook_Open and put it in a procedure
called Auto_Open in a regular code module, not the ThisWorkbook
module. Sometimes, Excel hasn't fully put itself together when
Workbook_Open runs.

Signature
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
> In an add-in I have created, a custom menu item is created, it
> is
[quoted text clipped - 18 lines]
> I haven't been able to figure it out. Any help would be
> appreciated.
Chip Pearson - 31 May 2006 22:29 GMT
I should have added that you should use the command bar name
rather than number. E.g.,
CommandBars("Worksheet Menu Bar").Controls("blah blah").Enabled =
True
Using the number seems unpredicable. For example,
Debug.Print CommandBars(1).Name
displays "WordArt" for me.

Signature
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
> Take your code out of Workbook_Open and put it in a procedure
> called Auto_Open in a regular code module, not the ThisWorkbook
[quoted text clipped - 23 lines]
>> I haven't been able to figure it out. Any help would be
>> appreciated.
mmmbert@yahoo.com - 31 May 2006 22:33 GMT
Thanks, that did the trick. I was hoping to avoid the enable macros
dialog, but I can live with it.
> Take your code out of Workbook_Open and put it in a procedure
> called Auto_Open in a regular code module, not the ThisWorkbook
[quoted text clipped - 6 lines]
> Microsoft MVP - Excel
> Pearson Software Consulting, LLC