Excel Protection

[kolly]

Hello People,

I have two questions.

1. How do I protect a section of an excel sheet such that someone cannot copy the section and paste anywhere else, but can only print out the section.

2. I have an excel work template, some rows of the template are hidden. Anytime you copy the template and paste elsewhere, it displays the hidden rows of the original template. Please how do I prevent the hidden rows displaying each time I copy and paste. I always want these rows hidden.

PLease help. Thanks a bunch!

Kolly.

 

[Bill Rockenbach]

Protection
It takes two steps to protect cells (Versions prior to 2007)
1. The cells to be protected need to be set to Locked. Select menu Format/Cells and Tab Protection. By default all cells are set to Protection when in a new worksheet. So you need to unprotect all the cells that you want the user to have access to change.
2. Protect the workbook. Select menu Tools/Protection/Protect Sheet. Select the type of protection you want and ender a password then click OK.
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
As far as coping hidden rows and columns, you can’t. But you can hide the rows and columns on the destination sheet before you make the copy/paste.
<o></o>
A vba procedure could do the job for you. Post details of what and where you copy if you are interested.

 

[kolly]

Thank you so much. You are too much.