ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Setting up and Configuration of Excel (https://www.excelbanter.com/setting-up-configuration-excel/)
-   -   I donot want anyone to make a copy of a sheet. (https://www.excelbanter.com/setting-up-configuration-excel/206591-i-donot-want-anyone-make-copy-sheet.html)

tina

I donot want anyone to make a copy of a sheet.
 
I want to disallow anyone from making a copy of an excel sheet. neither do i
want them to be able to save the sheet. how can i do this?

Dave Peterson

I donot want anyone to make a copy of a sheet.
 
Don't share it with people you can't trust.

I don't think there's anything you can do to stop someone from using windows
explorer to copy the file.

And anything you do in excel would depend on a macro (it would for me, at
least). And macros can be disabled.



Tina wrote:

I want to disallow anyone from making a copy of an excel sheet. neither do i
want them to be able to save the sheet. how can i do this?


--

Dave Peterson

ShaneDevenshire

I donot want anyone to make a copy of a sheet.
 
Hi,

The only way you can prevent people from making a copy of someting is to not
let them have access to it. For example, if they can open the file they can
do a screen capture using programs other than Excel. In other words if they
can see it they can copy it, although it may be a chore in some cases.

--
Thanks,
Shane Devenshire


"Tina" wrote:

I want to disallow anyone from making a copy of an excel sheet. neither do i
want them to be able to save the sheet. how can i do this?



All times are GMT +1. The time now is 02:44 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com