Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have protected the file, for viewing is fine. But I have try to copy and
paste to other worksheet. It can be copy over, which mean that all data can be view from here. (Copy file) My purpose to protected is not to allow other to copy over. |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hi sn,
Basically, you can't. The nearest you can get is to convert the file to a protected PDF, which you could then make available to those who are entitled to view it. PDF protection can be set to prevent either or both copying and printing. Cheers -- macropod [MVP - Microsoft Word] "sn" wrote in message ... I have protected the file, for viewing is fine. But I have try to copy and paste to other worksheet. It can be copy over, which mean that all data can be view from here. (Copy file) My purpose to protected is not to allow other to copy over. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
need to export row as csv file with column e plus .bom as file name | Excel Discussion (Misc queries) | |||
Retaining formats | Excel Discussion (Misc queries) | |||
how do I email amacro? | Excel Worksheet Functions | |||
copy file in value | Excel Discussion (Misc queries) | |||
Do not allow copy of file | Excel Discussion (Misc queries) |