How to update a xlsx sheet from another macro enabled sheet

[McJams]

I have a excel sheet which is shared through Google drive and used by google sheet.
When using the sheet as a standard xlsx sheet it is ok, but when I enable macros the sheet goes nuts.
All the sheets created by excel are moved to new sheets and only google sheet can be used.

Therefore I need to have all my macroes in another sheet which can update the xlsx sheet.
'
How am I supposed to do so?

Thanks in advance

[arlu1201]

Hello McJams,

Welcome to Excelforum. Be a part of large Excel community. Enjoy Learning.

[McJams]

Hi Arlu1201
thank you for your welcome salute.
Hi everyone
I am not so familiar with this kind of forum so please excuse me for maybe not do it in the right way.

i understand that a minor piece of my excel sheet is necessary but I am not sure what you need to look into.

My problem is that excelsheet with Macroes and other script are changed by google sheet and then they are not able to be used as a excel sheet.
I have attached a sample but the script does not work because it has been changed by google.

thanks in advance

Brgds
McJams