Disable print of opened workbook

[CsJHUN]

Hi guys, i would like to disable any kind of print option of the opened file (excel or ppt mainly).
There is a wb which contain the macro. In this wb there is ~4k link (let's says its a master list of xlsx, pptx, ....) I would like to diable any kind of printing possibilities on that files.
I thought i write a wb_deactivate/window_deactivate event then disable. After opened file are closed, the printing should be enabled again.

I familiar with wb_beforeprint event, but that should be in each and every file linked to this master list file, right? Also tried playing along with disabling the Print and Print... option (which not worked flawlessly ) but there is still the Ctrl+P shortcut

Any workaround, ideas, solutions?
Thanks

 

[YasserKhalil]

Maybe because I am using office 365. I remember there is a previous problem with that version.

 

[CsJHUN]

Glad to hear the code is working for you.... I am still curious to know why the same code doesn't work for YasserKhalil

imho its some Windows and or excel and or both version and or settings difference ("and or" sorry )