Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 167
Default Add in to spreadsheet

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

Thanks,
Pflugs
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 7,247
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 167
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
link a local spreadsheet to a network shared spreadsheet Leo Setting up and Configuration of Excel 1 March 21st 08 10:37 AM
Transmitting data from a server spreadsheet to a client spreadsheet gloryofbach Excel Programming 3 October 27th 05 11:23 AM
conversion of MS Works Spreadsheet to Excel 2002 Spreadsheet Kellie Excel Discussion (Misc queries) 1 March 24th 05 06:31 PM
Is there a way to insert a formula, password or macro in an excel spreadsheet that will automatically delete the spreadsheet? oil_driller Excel Discussion (Misc queries) 1 February 8th 05 09:34 AM
How to open another Excel spreadsheet to copy data into current spreadsheet ? Ricky Pang Excel Programming 0 July 13th 03 01:59 PM


All times are GMT +1. The time now is 09:32 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"