Errors when coying to another workbook

[ray1975]

Hello,

Let me explain my problem.

I have created a cost sheet for my restaurant that works quite well, with the help of forums and ChatGPT. I'm just a chef so be gentle

In the first workbook, "Costes", I do the cost calculation, and once finished I copy it to the "escandallo" book using a macro button.

The problem is that the macros from "Costes Esferic" are also copied, which causes errors. I would like only the sheet with the formulas to be copied, without the macros, and for it to be complete.

I have attached both books.

Any help will be greatly appreciated.

Cheers,
R

[Marc L]

Hola !

So do not copy the workbook but SaveCopyAs to a temp workbook file.
Open this temp workbook then SaveAs to standard format .xlsx : no more 'macro' included !
Then delete the temp workbook …

[ray1975]

Thank you for your reply Marc!

I managed to delete de macros but the problem comes from the following code, which is on the cost sheet and gets copied to the other sheet.

Please Login or Register  to view this content.

[ray1975]

Wait a minute, now I get it...

I saved it as .xlsx and I got rid of the errors. Anyway, would it be a more "elegant" way of sorting it out though?

Thank you so much !

[Marc L]

If the worksheet does not contain any code within its module so you can use the Copy method
to create a new workbook just containing the same worksheet …

[ray1975]

Ok, the next code is the one giving me the error and is located in VBAProject (COSTES.xlsb)/Objects/Sheet1
Should I put it somewhere else?

Both macros for copying and deleting are located in the Modules folder and they get deleted via macro with this code:

Thanks again!