How to prevent users to print Microsoft Word documents?
By agihcam
@agihcam (1914)
Philippines
1 response
@agihcam (1914)
• Philippines
20 Aug 08
Thanks for your interest with the excel.
Yeah, if you did not consider the other lapses then it will be useless.
Example, if the user did not enabled the macros, then it is useless already.
so to have robust file,
first, create a new sheet and named it anything you want, but put some text to inform user that such page was viewed when macro is disabled, so they cannot use the original work file unless they enabled the macro.
create a macro before closing the file, to hide the original sheet and shows the sheet that you have created, and automatically saved the file. so every time the file is closed by the user, the default visible sheet is the one you have created. so when they disabled the macros, it is the one showing up and not the original sheet.
then create an opening macro to view the original sheet and hide the sheet you have created, so when user enabled the macro, it will show the original sheet and hide the sheet you have created.
finally, disabled the print events. that's it.
1 person likes this


