tonywatsonhelp
Well-known Member
- Joined
- Feb 24, 2014
- Messages
- 3,210
- Office Version
- 365
- 2019
- 2016
- Platform
- Windows
Hi Everyone,
I have a document thats going to go out to over 200 people.
I have set it up with loads of macros stopping anyone from editing, changing and playing around with it, however there is still the possability that someone might think they know what they are doing and change things as password protection is easily cracked.
so as one last part of security I'd like to check when the document is opened that everthing is how it should be.
So heres what i was thinking.
have a macro that when the document opens checks the tab names,
I have a sheet called "control" in column Z I could list all the tabs in the document by Name,
The macro could then go in and check if any sheets exist that have a different name to this one,
Maybe we could also check the document name is the same as Control A7?
then if any of these errors exist I'd like a message box to pop up saying This document apears to have been tampered with and can no longer be used, please speak with you IT department to have this fixed!
and close the document down.
I know there will always be ways around this, but I think it would help stop the problem.
So if anyone know the macro to do this that would be great.
thanks
Tony
I have a document thats going to go out to over 200 people.
I have set it up with loads of macros stopping anyone from editing, changing and playing around with it, however there is still the possability that someone might think they know what they are doing and change things as password protection is easily cracked.
so as one last part of security I'd like to check when the document is opened that everthing is how it should be.
So heres what i was thinking.
have a macro that when the document opens checks the tab names,
I have a sheet called "control" in column Z I could list all the tabs in the document by Name,
The macro could then go in and check if any sheets exist that have a different name to this one,
Maybe we could also check the document name is the same as Control A7?
then if any of these errors exist I'd like a message box to pop up saying This document apears to have been tampered with and can no longer be used, please speak with you IT department to have this fixed!
and close the document down.
I know there will always be ways around this, but I think it would help stop the problem.
So if anyone know the macro to do this that would be great.
thanks
Tony