I have workbook which is updates very often daily and shared for users for
view. It meant for view only but I have to prevent users from copying by
using ctrl+c or right click and save as option in their computer. How can I
do it in my workbook?

One way, is to cancel the save action before it runs...... user does not
get any message, this of course does not stop them copying it using Windows
explorer! You might also consider putting in a check when the workbook
opens that it is opening from a specific folder. If the users disable macro
then saving is possible, here you might lock the application up and only
unlock it in the workbook open event, which will run only if macros are
enabled.

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As
Boolean)
Cancel = True
End Sub

--

Regards,
Nigel




"Narnimar" wrote in message
...
I have workbook which is updates very often daily and shared for users for
view. It meant for view only but I have to prevent users from copying by
using ctrl+c or right click and save as option in their computer. How can
I
do it in my workbook?