Macro Mystery
 

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

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

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