Archive of Mr Excel Message Board
Back to Dates in Excel archive index
Back to archive home
Protecting only formulasPosted 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.
Re: Protecting only formulasPosted 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")
ActiveSheet.Protect ("your password")
Re: Protecting only formulasPosted by Ara on August 23, 2001 1:20 PM
Thanks, I didn't think so, but I thought I would ask the experts.
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.