Save VBA changes only

  • Thread starter Thread starter PCLIVE
  • Start date Start date
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

--
 
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
 
Back
Top