I did a excel file for work, what i want is everybody can open it, but they can't save(save as) or copy it. how can do that?
Thanx
I did a excel file for work, what i want is everybody can open it, but they can't save(save as) or copy it. how can do that?
Thanx
here's one from J-Walk's excel for dummies
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
If SaveAsUI Then
MsgBox "You Cannot save a copy of this workbook!"
Cancel = True
End If
End Sub
this goes into a workbook module, search excel help if you need to find it
this won't let you save the workbook when you are in excel......
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks