View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Jim May Jim May is offline
external usenet poster
 
Posts: 477
Default Re-opening an Add-In

Tks, always appreciated Dave...

"Dave Peterson" wrote:

Addins are hidden.

You can open the VBE
Show the project explorer (ctrl-r)
Select the ThisWorkbook object in your project
Hit F4 to see the properties window

Change the IsAddin property to False
Back to excel to do what you want to

Then resave it as an addin.
(Not just an excel file with a .xla extension.)

Jim May wrote:

I've just encountered/learned that if I wish to "open" Test.xla file that I
earlier created -- and to add content to Sheet1, I cannot!!

When I double-click on Test.xla - up comes Book1.

Switching to the VBE - I do see the Test.xla project,
but with it currently selected I a unable to get to
the spreadsheet (App window) by clicking on the Excel
Icon (top - left).

What is someone to do if they need to do this?

Happy New Year !!


--

Dave Peterson