sheets(array(xx).copy create new workbook .xlsx while I want .xlsm without having to save

[TryToUnderstandExcel]

Hello there.

I have a question regarding:

Please Login or Register  to view this content.

The code copies the sheets xx1, xx2 and xx3 and creates a new workbook. The macro's inside the sheets are also copied.
The NEW workbook has the extension .xlsx which i want to be xlsm, to prevent people from saving the workbook without the macro's.

Is there anybody who knows how to change the .xlsx to .xlsm WITHOUT forcing to save?

Thanks!

[buran]

the new workbook created is not saved at the time of it's creation. so you have some other code that saves it. it's there that you specify the file type or if not it defaults to xlsx.

[Norie]

The most likely reason it has the xlsx extension is because that's what you've set the file format to be for new workbooks.

[TryToUnderstandExcel]

So Norie, you mean my question is how to set the file format for new workbooks to .xlsm? Is there a code to do so and after set it back to the regular setting?

[Norie]

Why do you need to have the file format as xlsm?

[Vikas_Gautam]

Buran is right.

Try using this.

Please Login or Register  to view this content.

Activeworkbook here means the new workbook.

[TryToUnderstandExcel]

Because otherwise people (who won't understand they will trow away macros) will save is as the default selected: xlsx.

Thanks Vikas, but in that way the workbook is saved, which I disfavor if it does not have to be.

[Norie]

If you want the file format of the workbook to be xlsm you will need to save it in that format.