Home > Archive > Visual Basic > October 2004 > Protecting an Excel Workbook
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Protecting an Excel Workbook
|
|
| Pambos Franjeskos 2004-10-27, 3:55 pm |
|
I have a large workbook with a lot of forulas in it. I;m planing to give
it to all my go workers to use it. I do not want the workbook to be
copied by no one. I did protected the cells and formulas and so on, but
I want to be able to secure the worksheet from been copied.
Any ideas on how to do that.
Thanks
Pambos
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
| |
| Paul Clement 2004-10-28, 3:55 pm |
| On Wed, 27 Oct 2004 06:23:03 -0700, Pambos Franjeskos <pfranjeskos@cybernet.ac.cy> wrote:
¤
¤
¤ I have a large workbook with a lot of forulas in it. I;m planing to give
¤ it to all my go workers to use it. I do not want the workbook to be
¤ copied by no one. I did protected the cells and formulas and so on, but
¤ I want to be able to secure the worksheet from been copied.
¤
¤ Any ideas on how to do that.
I would post your question to microsoft.public.excel if you don't receive an answer here.
Paul ~~~ pclement@ameritech.net
Microsoft MVP (Visual Basic)
| |
|
|
"Pambos Franjeskos" <pfranjeskos@cybernet.ac.cy> wrote in message
news:uzyiXgCvEHA.1296@TK2MSFTNGP10.phx.gbl...
>
>
> I have a large workbook with a lot of forulas in it. I;m planing to give
> it to all my go workers to use it. I do not want the workbook to be
> copied by no one. I did protected the cells and formulas and so on, but
> I want to be able to secure the worksheet from been copied.
>
Do you mean you don't want the XLS file copied? I don't think there's a way
to prevent that (unless you always keep the file opened...and even then,
there's probably a way around it).
Mike
|
|
|
|
|