Protection

  • Thread starter Thread starter Gary
  • Start date Start date
G

Gary

Hi,

I have set up an Excel Workbook that contains several
spreadsheets, and I have to send this out to various
people for comments.

In doing so, I want to lock all the cells and protect the
worksheet as best as possible so that anyone with any
comments will have to send their comments to me, rather
than update the workbook themselves (i..e I keep the
master copy and only myself can make any changes).

What is the best / most effective way of protecting the
entire workbook from alteration? i.e. how can I make it
as difficult as possible for a user to unlock my sheets?
I realise that there are always ways around it no matter
how sophisticated the protection is (i.e. I have a
password unblocker myself), but any help here would be
appreciated.

Many Thanks,

Gary.
 
Gary,

If you intention is that the 'readers' cannot use nor have any means of
accessing the date in your xls, then you might consider CopyPicture-ing your
sheets and pasting them in a new xls. That way you don't even need to
protect your resulting workbook by any means because there is nothing left
the reader can change or access.

Regards,
Bert
 
How do I do this??

-----Original Message-----
Gary,

If you intention is that the 'readers' cannot use nor have any means of
accessing the date in your xls, then you might consider CopyPicture-ing your
sheets and pasting them in a new xls. That way you don't even need to
protect your resulting workbook by any means because there is nothing left
the reader can change or access.

Regards,
Bert

"Gary" <[email protected]> schreef in bericht


.
Click to expand...
 
If you want to do it manually to see the result, then select the (part of)
the sheet you want to CopyPicture, then push Shift, select edit from the
menu and you'll see Copy changed into Copy Picture. I assume the rest is
obvious.

If you want to automate, the function CopyPicture is available in VBA too.

Regards,
Bert
 
Gary, select the data you want to copy, hold the shift key down, click on
edit, copy picture, paste on a new sheet or in a new workbook

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2000 & 2003
** remove news from my email address to reply by email **
 
OK,

These are great!!

The only problem being that the formulae do not appear on
the "Copied Picture", which may present a problem for some
of the users as they may not understand where the results
are derived from.

Therefore I ask the follow-on question:

What's the most secure way of sending out a workbook that
allows the users to see formulae underpinning each cell
but does not allow them to alter it??

Is it simply putting a Password on each sheet and making
sure all cells within those sheets are locked?? Or is
there anything more sophisticated?

Many Thanks for your help,

Gary.
 
Password protecting the worksheet to prevent user changes is worthless.
See

http://www.mcgimpsey.com/excel/removepwords

I'd suggest using the method you've had suggested, and then a second one
after you type CTRL-` (accent grave, above the tab key on a US keyboard)
to display the formulae.

Note, however, that showing the formulae, unless there are macros, will
allow the user to recreate the workbook to make it essentially identical
to the original, so I'm not sure what good that does you.
 
Back
Top