I have an Excel document that I need to secure. By that, I mean that it can be viewed by anyone, but it cannot be changed or printed. Is this possible?
Thanks!
Betty
I have an Excel document that I need to secure. By that, I mean that it can be viewed by anyone, but it cannot be changed or printed. Is this possible?
Thanks!
Betty
Last edited by bettyscp; 04-09-2009 at 12:45 PM.
Excel is intrinsically not a secure environment.
To approach this, you'd need to force the user to enable macros in order to see any of the information, then have code that cancels printing. You'd need code that purges the clipboard when the workbook is deactivated to prevent copying and pasting to another application (you could protect the worksheets to prevent cell selection in the first place, but that is trivial to break.)
The motivated user will then just copy the screen and then print that.
Entia non sunt multiplicanda sine necessitate
Thank you!
"The motivated user will then just copy the screen and then print that." -- I was pretty sure that would be the case.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks