Any chance you have an example of this code to Protect and Unprotect the
sheet???



"Dave Peterson" wrote in message
...
You can modify your code to unprotect the worksheet, make the changes,
then
reprotect the worksheet.

HotRod wrote:

I found that when I did this some of my VBA code was not working
properly,
specifically trying to change the interior ROW colour.

"Chip Pearson" wrote in message
...
Select all the cells in your worksheet, go to the Format menu, choose
Cells, then the Protection tab. There, uncheck the Locked property and
click OK. Now select rows 1:3, go back to the Protection tab, check the
Protection tab, and click OK. Finally, go to the Tools menu, choose
Protection, and Protect Sheet.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

"HotRod" wrote in message
...
IS there a way, either in VBA or just excel to lock the header rows
(Rows
1 -3) so that they can not be Edited or deleted?




--

Dave Peterson