shatonak2004k
New Member
- Joined
- Jun 16, 2021
- Messages
- 2
- Office Version
- 2019
- 2016
- 2013
- 2011
- 2010
- 2007
- Platform
- Windows
hi, I embed an excel file by One drive, and as you know, its downloadable, so I use an "Macro" , to delete Downloaded file, by user, immedialtly after open file, so if user donot enable "Macro", its not possible to delete file, so i search and found a famous method to "force user to enable Macro" by use an notification sheet and "veryhidden" sheets properties, to do so.
now here is my problem, i am capable of protecting my file, by using an Macro code to delete Downloaded file and capable to "force user to enable Macro", as well, but this makes my sheets hidden on embedded web version of my file, as well.I need my sheets be visible on web version of my file and capable of deleting Downloaded version by Macro code as well.
NOW, CAN YOU HELP ME.
now here is my problem, i am capable of protecting my file, by using an Macro code to delete Downloaded file and capable to "force user to enable Macro", as well, but this makes my sheets hidden on embedded web version of my file, as well.I need my sheets be visible on web version of my file and capable of deleting Downloaded version by Macro code as well.
NOW, CAN YOU HELP ME.