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)



"Pflugs" <(E-Mail Removed)> wrote in message
news:50CE3816-4800-4560-B0FF-(E-Mail Removed)...
> How do I save an add in back to a spreadsheet for editing?
>
> Thanks,
> Pflugs

Thanks!

"Chip Pearson" wrote:

> 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)
>
>
>
> "Pflugs" <(E-Mail Removed)> wrote in message
> news:50CE3816-4800-4560-B0FF-(E-Mail Removed)...
> > How do I save an add in back to a spreadsheet for editing?
> >
> > Thanks,
> > Pflugs
>