View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mike Mike is offline
external usenet poster
 
Posts: 3,101
Default Restricted Save As option to all work stations

Saving is the easy bit, use

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
msg = "I don't want you to do that"
MsgBox (msg)
If SaveAsUI = True Then Cancel = True
End Sub

For preventing cut, copy and paste etc look here.

http://www.vbaexpress.com/kb/getarticle.php?kb_id=373


"Salman" wrote:

Hello,
I have a database of 180 workbooks with multiple sheets on sharing through
network drive, soem user have read+write rights and some have read-only
rights.

I want to protect every workbook that no one, specially with the read only
rights, can save the workbook on their desktop and Copy Paste the workbook as
a file on their hard disk.

Is there any suggestion, it would be relly helpfull