Start up file doesn't open

J

jc

I have a file that is in my designated startup file that is suddenly not
opening after haveing opened fine on start up for a long time.

I am able to open the file manually. When I do there is an error auto open
code:

..Item("Data").Controls.Item("Sort...").OnAction = "Sort"

The message is: Run-time error '-2147467259' (80004005)':
Method 'OnAction' of object '_CommandBarButton'
failed

Any thoughts on if these two problems a related and what is cousing them?
 
J

jc

I just noticed that a file that when I open a file that is normaly open after
the startup file that the start up file then opens and the auto open macro
runs fine.

There are know links showing in either file
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Error in CommandBars 5
Automation error with XLA addin, fails on commandbarbutton onaction 0
Run time error '-2147467259 (80004005) adding icon 3
Error -2147467259 (80004005) Method 'xxxx' of object 'yyyy' faile 3
Error when creating menu item on command bar 2
XLStart File doesn't open when Excel Opens 2
macro works on F8 but not auto 6
Method ‘Add’ of object ‘CommandbarControls’ failed 1

Top