Excel

D

Doobage20

How do I make an Excel file with macros modifiable on the network but also
have it set to not be copied. The file is accessed by a shortcut on
everyones desktop. Clients are using XP/2000 and the server is 2000. Office
is 2000 Pro.

Thanks

Mark
 
D

Doobage20

I found out that modify rights were not needed. So I have given everyone
Read and List permissions only. How would I prevent them from copying the
file.

Thanks,

Mark
 
B

Bob I

I'll try this again. In order to prevent copying you would need to
prevent writing to ANY location.
 
D

Doobage20

I quess I am confused on the prevent writing to any location part. Does that
mean that no client can write to anywhere on the server or just in that
directory?

Mark
 
G

Gary Smith

You can't. If they can read, they can copy.


Doobage20 said:
I found out that modify rights were not needed. So I have given everyone
Read and List permissions only. How would I prevent them from copying the
file.


"Bob I" wrote:
Click to expand...
 
B

Bob I

If they have permission to read the file and they have permission to
WRITE to ANY location whatsoever(floppy, usb stick, local HD, server
directory, e-mail) they can COPY it. Hope this explanation clears it up.
 
K

Keme

Bob said:
In order to prevent copying you would need to prevent writing to any
location.
Click to expand...

What is the purpose of disallowing copy?

- If you want to hide the formulas or disable cut/paste, you can lock
the worksheet with password protection, and disallow selection of cells.

- If you want to show the content but prevent a file copy, you could
possibly hide the excel file, then make it available as a data source.
Windows ODBC has excel drivers, which indicates that you should be able
to use excel worksheets as source for database service. I haven't tried
it, though.

The "worksheet lock scenario" won't stop copying of the file.

In the "database scenario" (if it works), although the file isn't
available for copy, the cells will probably be available for copy/paste
(value content only, no formulas, I guess).
 
Top