View Single Post
  #4   Report Post  
Vikrant Vaidya
 
Posts: n/a
Default

Right Herald! Good thing it occured to you!
And yes the example too was quite amusing....

Vikrant

"Harald Staff" wrote:

Hi Kalz

Vikrant covered the protection part. This just to warn you: DO NOT include
anything in the file that the recipient shouldn't see. It is very easy to
get to that information, even by accident, no password cracker involved.
Don't hide those rows or columns, delete them.

Just to demonstrate, try this in a new file:
A1: You're the
B1: stupidest
C1: man

Hide B column. Protect the worksheet. You should see the flattering "You're
the man" and be unable to unhide B.

Now select A1:C1 with the mouse. Copy. Go to another sheet. Paste.

HTH. Best wishes Harald


"kalz" skrev i melding
...
Dear All,

I'd like to email my customer a Excel worksheet, however, do not want them
to change any cells (values and formats) from column A to D, only E and
onwards permitted. Also, if I have hidden some rows or column, I do not

want
the person to view my hidden parts too.How can I created this effect? I
already tried Protect Worksheet and workbook, doesn't seem to be working.

Thankyou!
kalz