Removing macros on save

[peakoverload]

I already have a workbook which we call a Job Sheet Generator. This is a macro enabled workbook and on it I have a button which when clicked triggers a macro which then saves it as a new workbook which is also macro enabled.

What I need to do now though is have it so that the new workbook is not saved as a macro enabled one because the new workbook has to work online in a browser and in teams.

The macro I was using was:

Please Login or Register  to view this content.

I've tried changing it to FileFormat:=51 and the extension to sTitle = Range("D1").Value & ".xlsx"

But when I run it I still get a warning saying:

The following features cannot be saved in macro-free workbooks

VB Project

Is there a way to keep the macros in the 'job sheet generator' but remove them from the workbook it saves?

[Mumps1]

Please ignore.

[Fluff13]

Change this

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

and then use

Please Login or Register  to view this content.

[MarvinP]

Hi,
A few guesses from me.
Did you turn off your Application.DisplayAlerts = False and on again after saving?
Second:
I was reading about Save a Copy instead of Save As on this site:
http://www.learnexcelmacro.com/wp/20...of-a-workbook/
which also might be your problem.
Third:
I don't think any Macro's run while the file is on Teams, unless there is something new with Teams. Read:
https://techcommunity.microsoft.com/...ams/m-p/292121
Were you thinking the file would have the same function on Teams as it did on your own machine?