View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Papa Jonah Papa Jonah is offline
external usenet poster
 
Posts: 148
Default Close a workbook without saving macros

I have a workbook with a number of macros. One of the macros saves the file
as with a name provided through an input.

However, the orignial workbook then has a list of all of the macros
duplicated with references to the newly saved file.
I want the original workbook's macros to stay - unchanged so that it can
then be reused as a template.

Any ideas?

TIA