Deny print access to specific files 1

[zarkon4]

How would I deny a user the ability to print certain files from a network share. These users need to view the files but cannot print them.

 

[paladin256]

You would need to use some form of digital rights management I would think on the files in question because you only set read, write, create, modify, etc on files through windows or set who has access to certain printers.

 

[Steve Bowman]

by creating a macro in the worksheet and adding

Private Sub workbook_BeforePrint(Cancel As Boolean)

    Cancel = True

    MsgBox "Sorry, you cannot Print from this workbook", vbInformation

End Sub

this is not heavy protection but will work for a majority of end users. also the workbook_Befor???????? works for many menu functions like workbook_BeforSaveAs and so on and is a functional event hook.

Steve Bowman
Independent Technology, Inc.
CA, USA

 

[zarkon4]

The directories have other types of files, .dwg, .txt, .jpg, .tif, .pdf.

Thanks anyway.