ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Save VBA changes only (https://www.excelbanter.com/excel-programming/429891-re-save-vba-changes-only.html)

Dave Peterson

Save VBA changes only
 
The code is saved with the workbook--along with the worksheets and all the other
info.

Maybe it's time to consider separating your code into a different workbook
(maybe an addin) and keep the data in a completely different workbook.

You could tell the users to install the addin (tools|addins in xl2003 menus) or
just open the addin when they need the macro functions.

PCLIVE wrote:

Is there away to just save the VBA changes without saving other data in the
workbook? For example, I'm using a template that imports data from another
workbook when it is opened. Now I want to add or change some of the code
within the workbook and save it. However, I do not want to save the
imported data.

Is this possible?

Thanks,
Paul

--


--

Dave Peterson


All times are GMT +1. The time now is 07:22 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com