Save VBA changes only

P

PCLIVE

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

--
 
P

Patrick Molloy

alternatively export all the changed modules - you can just "drag" thenonto
the desktop.
then re-open the workbook, delete the changed modules from the workbook, and
then drag them in off the desktop
then use EDIT/ Compile
 

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

VBA editor doesn't prompt to save changes, doesn't save 3
vba code does not run 3
Saying No to Message Box prompt through VBA 6
"Do you want to save changes?" question 5
Overriding the menu "Save" option? 4
Deleting Code and saving 3
deactivate save changes 1
Open a word mail-merge document from Excel VBA 1

Top