Archive of Mr Excel Message Board

Back to Dates in Excel archive index
Back to archive home

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

Re: Protecting only formulas

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

Re: Protecting only formulas

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

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.