Thread: Macro Mystery
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default Macro Mystery

Only if you then save the file with the same name. If you use File |
Save As then you can save the file with a different name, and the
original workbook will be untouched.

Hope this helps.

Pete

On Feb 26, 7:42 pm, Wanna Learn
wrote:
Hello
I want to create a new workbook using 3 worksheets,(these worksheets have
formulas, I know how to do this part my problem is that I only want the
values on the new workbbook. If I include in the macro copy and paste
special values will my formulas on the orginal workbook be deleted. ?