Protect a workbook when password is disabled
How can I protect an excel workbook solution I’m doing at work on my own. It is lodged in a remote server. 1) To safely back it up, I cannot save it to a portable memory key. I can receive e-mails there but I cannot send them, thus I cannot send the file as an attachment either. 2) The access and modification password feature are disabled and so are the ones at worksheet and cell level.
1) How can I extract a copy? – 2) How can I protect it or?
I want to be able to create a macro that works in conjunction with an idea I saw here to force people to first having to enable macros and also create a macro time based that will close the workbook, or will stay in a blank worksheet, if the value in a cell is not the correct one. Another more dramatic option I would like to consider is self-destruction – the whole worksheets and but one macro get wiped out without recourse. Either those options or I welcome any ideas. Somebody is sneaking into my file and trying to steal my work. Thank you very much for your attention and help . . .
How can I protect an excel workbook solution I’m doing at work on my own. It is lodged in a remote server. 1) To safely back it up, I cannot save it to a portable memory key. I can receive e-mails there but I cannot send them, thus I cannot send the file as an attachment either. 2) The access and modification password feature are disabled and so are the ones at worksheet and cell level.
1) How can I extract a copy? – 2) How can I protect it or?
I want to be able to create a macro that works in conjunction with an idea I saw here to force people to first having to enable macros and also create a macro time based that will close the workbook, or will stay in a blank worksheet, if the value in a cell is not the correct one. Another more dramatic option I would like to consider is self-destruction – the whole worksheets and but one macro get wiped out without recourse. Either those options or I welcome any ideas. Somebody is sneaking into my file and trying to steal my work. Thank you very much for your attention and help . . .
