Macro Mystery

W

Wanna Learn

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. ?
 
P

Pete_UK

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
 
P

Pete_UK

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
 
Top