K0st4din
Active Member
- Joined
- Feb 8, 2012
- Messages
- 488
- Office Version
- 2016
- 2013
- 2011
- 2010
- 2007
- Platform
- Windows
Hello, everyone,
recently in the office my superior asked me a question, the tables we share through google excel sheets can be made so that they are deleted after a certain period by themselves.
I have such a macro, which works perfectly on the computer, and I thought that I could put it in the excel table, which is located in google drive and is opened through google excel, but when I entered to put it, it turned out that the macros are written there in a slightly different way and I can't get it right.
((((
Here's what I do:
I upload an excel table to google drive, open it in excel, there are 2 sheets in the file itself. I press the share button to a colleague (as the entire table is restricted to copy, download, in a word, to view only.
When 20 days pass, I go into google drive and delete it so that the table is no longer viewed.
From what I've read, and quite a while, there is no way (or I haven't found) that I can set a time period for these tables to be deleted.
For this reason, I decided to look for a way to at least delete the 2 worksheets in the excel file.
My request is if someone can help me how to do these things because there are times when I just forget about the tables and they stay longer visible until the information is removed.
I remain available if you have any questions and thank you in advance.
recently in the office my superior asked me a question, the tables we share through google excel sheets can be made so that they are deleted after a certain period by themselves.
I have such a macro, which works perfectly on the computer, and I thought that I could put it in the excel table, which is located in google drive and is opened through google excel, but when I entered to put it, it turned out that the macros are written there in a slightly different way and I can't get it right.
((((Here's what I do:
I upload an excel table to google drive, open it in excel, there are 2 sheets in the file itself. I press the share button to a colleague (as the entire table is restricted to copy, download, in a word, to view only.
When 20 days pass, I go into google drive and delete it so that the table is no longer viewed.
From what I've read, and quite a while, there is no way (or I haven't found) that I can set a time period for these tables to be deleted.
For this reason, I decided to look for a way to at least delete the 2 worksheets in the excel file.
My request is if someone can help me how to do these things because there are times when I just forget about the tables and they stay longer visible until the information is removed.
I remain available if you have any questions and thank you in advance.
