View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson[_5_] Dave Peterson[_5_] is offline
external usenet poster
 
Posts: 1,758
Default Add-In will not allow worksheet to be opened.

First, check to make sure the workbook isn't actually open:

Window|Arrange|Tiled

If it's not visible, then sometimes one of these works:

Tools|Options|General|Ignore other applications (uncheck it)

--- or ---

Close Excel and
Windows Start Button|Run
excel /unregserver
then
Windows Start Button|Run
excel /regserver

The /unregserver & /regserver stuff resets the windows registry to excel's
factory defaults.


Chad wrote:

When I double click on an Excel file and I have a particular add-in
installed, Excel opens but the file I double clicked on does not. If I have
Excel opened first, when I double click on the file it will open.

Any thoughts?

Chad


--

Dave Peterson