ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Read- only Protect Folders and contents in WIN2K Server (https://www.excelbanter.com/excel-discussion-misc-queries/116846-read-only-protect-folders-contents-win2k-server.html)

Tommydraw123

Read- only Protect Folders and contents in WIN2K Server
 
I can protect the Word and Excel Documents. But how do You protect the files
from being Copied, Headers and Footers changed Changed or Moved. I tried
the read only allow function and deny everything else, but it still allows
it to do all of these things.

Dave Peterson

Read- only Protect Folders and contents in WIN2K Server
 
I don't think you can stop the workbooks/files from being copied. The user
could use windows explorer to copy to any location they want.

And any solution would probably include macros and macros can be disabled.

And you can't stop headers and footers from being changed either. But a
workaround that depends on macros being enabled is to (re)apply the headers and
footers to every worksheet that you want in the _beforeprint event.

Again, if macros are disable, then this won't help.

Tommydraw123 wrote:

I can protect the Word and Excel Documents. But how do You protect the files
from being Copied, Headers and Footers changed Changed or Moved. I tried
the read only allow function and deny everything else, but it still allows
it to do all of these things.


--

Dave Peterson

Tommydraw123

Read- only Protect Folders and contents in WIN2K Server
 


"Dave Peterson" wrote:

I don't think you can stop the workbooks/files from being copied. The user
could use windows explorer to copy to any location they want.

And any solution would probably include macros and macros can be disabled.

And you can't stop headers and footers from being changed either. But a
workaround that depends on macros being enabled is to (re)apply the headers and
footers to every worksheet that you want in the _beforeprint event.

Again, if macros are disable, then this won't help.

Tommydraw123 wrote:

I can protect the Word and Excel Documents. But how do You protect the files
from being Copied, Headers and Footers changed Changed or Moved. I tried
the read only allow function and deny everything else, but it still allows
it to do all of these things.


--

Dave Peterson
Thanks Dave that didn't answer any questions that were asked. These are hard question to answer I know.


Dave Peterson

Read- only Protect Folders and contents in WIN2K Server
 
What question didn't get answered?

The one about copying the workbook or the one about the headers/footers?

Tommydraw123 wrote:

"Dave Peterson" wrote:

I don't think you can stop the workbooks/files from being copied. The user
could use windows explorer to copy to any location they want.

And any solution would probably include macros and macros can be disabled.

And you can't stop headers and footers from being changed either. But a
workaround that depends on macros being enabled is to (re)apply the headers and
footers to every worksheet that you want in the _beforeprint event.

Again, if macros are disable, then this won't help.

Tommydraw123 wrote:

I can protect the Word and Excel Documents. But how do You protect the files
from being Copied, Headers and Footers changed Changed or Moved. I tried
the read only allow function and deny everything else, but it still allows
it to do all of these things.


--

Dave Peterson
Thanks Dave that didn't answer any questions that were asked. These are hard question to answer I know.


--

Dave Peterson


All times are GMT +1. The time now is 09:44 PM.

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