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: 126
Default Excel startup settings

This evening I ran into a problem with starting excel or more precisely
opening workbooks.
I was writing some code in an addin I am developing. As close as I can
recreate the problem it went something like this:

I opened MyAddin which automatically opens MyFile. I created a new Forms
command button on MyFile and opened the dialog to assign a macro. Since the
target macro is in MyAddin it didn't show up on the list (as expected). I
typed in the macro name (BUT critically, I think I forgot to enter
"MyAddin.xla!" to fully qualify the location of this macro). When I clicked
the button, it started another addin (Rob Bovey's VBA CodeCleaner) which
crashed in mid procedure.

I'm not sure how started this sub but I suspect that lacking a fully
qualified assigned name, my button click caused the program to search thru
all available addins til it locates one with the name I assigned to the
button.

The problem now is that the above mentioned crash seems to have left some
excel setting modified (which I assume would have been re-set if I could have
completed the CodeCleaner procedure).

The current symptom I am having is that whenever I click on a workbook icon
in the desktop or wherever, an instance of Excel is opened but the particular
workbook does NOT open. (I get the same blank grey screen that I get whenever
I close all workbooks, but have not closed the xl program.) I can then use
FileOpen and find the file again and open it, or click on New to open a new
wbk.

So, the question: Is there a way to re-set some property of Excel so I can
directly open files from the window icons?

TIA
 
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
Is there a settings startup file for Excel? JimG Setting up and Configuration of Excel 5 September 27th 09 09:24 PM
Excel startup Raju Excel Discussion (Misc queries) 5 August 25th 09 03:53 AM
Excel Startup Rrrock L Excel Discussion (Misc queries) 1 April 22nd 09 06:09 PM
Change Startup Settings Slave2Six Excel Discussion (Misc queries) 4 August 1st 06 08:03 PM
Excel Startup Zygan Excel Discussion (Misc queries) 1 May 14th 06 12:53 PM


All times are GMT +1. The time now is 08:48 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"