How to update a xlsx sheet from another macro enabled sheet

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 or find another way te ensure that sheets does not change.
i have attached a sample of the sheet but does not really work because of the google change

'
How am I supposed to do so?

Thanks in advance

As far as I know VBA doesn't work in Google Sheets and usually in online Excel applications.

The only solution I can think of is to export the modules to a folder before saving the file as XLSX, then import them back when when saving the file back on the computer to work on it.

There is an Import-Export code proposed by Ron de Bruin in here:
https://www.rondebruin.nl/win/s9/win002.htm

I hope it helps.

Hi Mrrr

Thank you for replying ro my issue.
I was not aware that Google changed the sheetname when sharing the workbook when macro are enabled.
I can see that I am able to share the workbook as a *.xlsx and then no change are made for the codename and sheetname.

What I would like to do is:
Have a workbook with all the scripts and macros, run it from the local workbook which update the *.xlsx project that are shared. I hope this should leave the shared project file as a .xlsx and google will not change sheets name.

I will of course try your solution to see if it will work.

Otherwise I might have to develope the workbook with javacode but prefer to use VBA

Thanks.