workbook gets corrupted when download to computer from google sheet. vba stops working.

[west123]

Hi, would like to get get help to get a full copy of this workbook to be downloaded to computer from google sheets, without vba to stop working or formulas.
the buttoms with vba are Limpar, ocultar exibir and also there is an Add 1000 more rows at the bottom of sheets
Com straight X, Sem straight X and, C�pia de Scoop Overall
this is the google link to the file https://docs.google.com/spreadsheets...it?usp=sharingadd.png

[6StringJazzer]

The link is to an Excel file with no macros. Google Sheets doesn't support VBA or ActiveX. If you want to store this in the cloud you should store it in Google Docs, not Sheets.

[west123]

thank you 6StringJazzer
this is the original link that was share to me. 6StringJazzer https://docs.google.com/spreadsheets...#gid=250879172
what i did was make a copy and store in google drive thats the link i am sharing in post#1 when i download from above link here to pc file gets corrupted, so i am not sure how to go about getting full copy from this link original that was share.
when i click original link to save copy i get this

new link not sure if this one will show vba https://docs.google.com/spreadsheets...it?usp=sharing

[MrShorty]

Does the file use macros? Were the macros designed and implemented using Google's Apps script? If so, you cannot simply download the file to Excel and expect those macro scripts to work. You are going to need to somehow adapt those scripts into a macro language that works with Excel. My understanding is that Google Apps script is Javascript (or very close to Javascript), so it might be easiest to adapt the Apps script code to work with Excel using Javascript: https://learn.microsoft.com/en-us/of...api-for-office

[west123]

thank you Mr.Shorty,
yes file has 4 buttons that use macros. thats very complicated. as i no anything about macros and scripts. though it would be easier than what u mention above.

[MrShorty]

In my experience, one of the fastest ways to get yourself locked into using one and only one spreadsheet app is to build a spreadsheet that uses macros. Each spreadsheet app has its own way of interacting with the macro language, so it is usually difficult to move a file from one spreadsheet app to another once you have added a macro to the file. If you don't have the expertise to adapt the macros to Excel, and the spreadsheet's developer won't help you move the spreadsheet file into Excel, I would suggest using the file in Google sheets and not worry about exporting it to Excel.

[west123]

i see, were you able to see the buttons with the vba code, and what they do?
Limpar, ocultar exibir and also there is an Add 1000 more rows at the bottom.
i don't feel save with the google version as i don't know if they can hack me or if is sending information as a message says when i give acess to the vba code. would it be to much work to have someone here help with the vba in the buttons that need it ? I am pretty much stock with this problem now
this message, and since i want to have this file ready to use when i decide to leave the country to go play online poker from i mean i don't want anyone having acess or to be able to see my whole cards while i play.

[MrShorty]

It's not the kind of programming I do, so I can't help with this sort of thing. Perhaps one of our other users will step in and offer some help.

Since we'll kind of end up rebuilding the spreadsheet from the bottom up, perhaps the best place to start would be a basic description of what the spreadsheet is supposed to be doing. Then we won't need to reverse engineer the existing Google Sheets spreadsheet before programming new stuff.

[west123]

okay, hopefully someone steps in to help with whats needed.

[west123]

these is the 4 things needed in the vba buttons
1. Limpar = to clean
2. Ocultar = Hide
3. Exibir = to show
4. add 1000 more rows at the bottom
the button Ocultar hide the columns T:AH and
the button Exibir show the columns back