When you release the mouse button you will see the copy of the sheet.

B) Use a Sheet template(xlt, xltx or xltm) How do I create one: 1: Open a new workbook and delete all worksheets.

With the macro example below you can select the template that you.

This can be a big waste of time; especially if there are many sheets andor you have to regenerate the PDFs every time the content changes.

The Fname variable can be used to customize the PDF file names that are generated.

All the worksheets contain tech data and have different names.

Save An Excel Sheet As New Code Above And

I put in the following from your code above and nothing happened.

Is it possible to save the files as the name the worksheet has Not the sheetnumber.

Since Im saving about 100 sheets my desktop gets really full.

Ive been trying to find something to create PDFs from every worksheet for a while now.

Works like a charm.

Required a bit of tuning your own situation, but itll save so much time.

Ive bookmarked this site now and hope to find more useful tools.

How To Save An Excel For Mac Sheet As New