Add in to spreadsheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I save an add in back to a spreadsheet for editing?

Thanks,
Pflugs
 
You can change the IsAddin property to False. In the VBA Editor, open your
add-in project then press CTRL+g to display the Immediate window. Type the
following in the Immediate window and press Enter:

ThisWorkbook.IsAddin = False

When you are done editing, do the same thing but change "False" to "True"
and then save the project.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting
www.cpearson.com
(email on the web site)
 
Thanks!

Chip Pearson said:
You can change the IsAddin property to False. In the VBA Editor, open your
add-in project then press CTRL+g to display the Immediate window. Type the
following in the Immediate window and press Enter:

ThisWorkbook.IsAddin = False

When you are done editing, do the same thing but change "False" to "True"
and then save the project.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting
www.cpearson.com
(email on the web site)
Click to expand...
 
You must log in or register to reply here.

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

Test for existance of data validation 2
Insert Command accidentally deleted from Cell Menu 2
Custom Floatable Toolbar Popup Menu 6
Audio Files Metadata 2
Passing a Forms Control to Function 5
Character Locations in Strings 2
Application object missing? 1
Macro works but also runs original spreadsheet 5

Back
Top