Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Add in to spreadsheet
How do I save an add in back to a spreadsheet for editing?
Thanks, Pflugs |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Add in to spreadsheet
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" wrote in message ... How do I save an add in back to a spreadsheet for editing? Thanks, Pflugs |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Add in to spreadsheet
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" wrote in message ... How do I save an add in back to a spreadsheet for editing? Thanks, Pflugs |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
link a local spreadsheet to a network shared spreadsheet | Setting up and Configuration of Excel | |||
Transmitting data from a server spreadsheet to a client spreadsheet | Excel Programming | |||
conversion of MS Works Spreadsheet to Excel 2002 Spreadsheet | Excel Discussion (Misc queries) | |||
Is there a way to insert a formula, password or macro in an excel spreadsheet that will automatically delete the spreadsheet? | Excel Discussion (Misc queries) | |||
How to open another Excel spreadsheet to copy data into current spreadsheet ? | Excel Programming |