MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Protecting only formulas


Posted by Ara on August 23, 2001 9:01 AM

I want to protect certain formulas in a spreadsheet. I still want the user to be able to insert rows. If I select protect the document, it protects my formulas but doesn't allow a user the ability to enter rows. Is this possible?

I appreciate any help I can get.

Thanks


Posted by Barrie Davidson on August 23, 2001 11:33 AM

Sorry, it's only possible to do this with VBA. The following code can do this.

ActiveSheet.Unprotect ("your password")
ActiveCell.EntireRow.Insert
ActiveSheet.Protect ("your password")

Regards,
Barrie

Posted by Ara on August 23, 2001 1:20 PM

Thanks, I didn't think so, but I thought I would ask the experts.

Thanks