ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Make a file not capable of copying (https://www.excelbanter.com/excel-discussion-misc-queries/147510-make-file-not-capable-copying.html)

stetka

Make a file not capable of copying
 
I have a worksheet with prices that I don't want customers to copy from and
make their own pricing. Is this possible?

Jim Rech

Make a file not capable of copying
 
Afraid not. Excel is a very insecure environment.

--
Jim
"stetka" wrote in message
...
I have a worksheet with prices that I don't want customers to copy from
and
make their own pricing. Is this possible?




stetka

Make a file not capable of copying
 
Thanks for your help. Can I add a disclaimer pop up?

"Jim Rech" wrote:

Afraid not. Excel is a very insecure environment.

--
Jim
"stetka" wrote in message
...
I have a worksheet with prices that I don't want customers to copy from
and
make their own pricing. Is this possible?





Jim Rech

Make a file not capable of copying
 
You can add a macro that pops up a message when the workbook opens:

Sub Auto_Open()
MsgBox "Do Not Copy!", vbInformation, "Disclamer"
End Sub

But that depends on the user enabling macros.

Another option is a new worksheet with your disclamer, which you make the
active worksheet when you save it. Granted users can later save the
workbook with another sheet active but you know they will see it the first
time at least.

--
Jim
"stetka" wrote in message
...
Thanks for your help. Can I add a disclaimer pop up?

"Jim Rech" wrote:

Afraid not. Excel is a very insecure environment.

--
Jim
"stetka" wrote in message
...
I have a worksheet with prices that I don't want customers to copy from
and
make their own pricing. Is this possible?








All times are GMT +1. The time now is 12:20 AM.

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