Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-26-2012, 03:03 AM
b-baker b-baker is offline Protecting Worksheets in Excel 2010 Windows 7 32bit Protecting Worksheets in Excel 2010 Office 2010 32bit
Novice
Protecting Worksheets in Excel 2010
 
Join Date: Feb 2012
Posts: 2
b-baker is on a distinguished road
Default Protecting Worksheets in Excel 2010

I'm stuck!

I am trying to protect a worksheet in an excel workbook but I already have protected cells within the sheet.

I know how to protect the cells using locked cells but I want to protect 4 out of 5 sheets for being editable but when un locked leave the protected cells protected.

Example on attached spreadsheet:
I don't want the Title (A1), Ref No. (A3), Notes (B3) or the Ref numbers (A4:A8) to be editted on all the sheets
I also want to lock sheets2:5 so only sheet 1 can be editted, without changing the protected cells.



#All cells are unprotected in the example

Is there an easier way to do this than unprotecting all the cells and re-protecting everytime I want to open up another sheet?

Thanks for any help.
Attached Files
File Type: xlsx Protecting Sheets.xlsx (10.7 KB, 9 views)
Reply With Quote
  #2  
Old 04-27-2012, 01:38 AM
grizz grizz is offline Protecting Worksheets in Excel 2010 Windows XP Protecting Worksheets in Excel 2010 Office 2003
Novice
 
Join Date: Jan 2012
Posts: 28
grizz is on a distinguished road
Default

I may be missing somthing but if you lock cells A1 A3 and A4:A8 and all other cells are unlocked and then sheet is password protected you can edit all cells except A1 A3 & A4:A8
I changed your sheets to show this >>> to unprotect sheet just go unprotect [ no password required ]
Attached Files
File Type: xls Copy of Xl0000295.xls (25.5 KB, 6 views)
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Protecting Worksheets in Excel 2010 Merge from 2 excel worksheets apolloman Mail Merge 2 06-02-2011 04:16 AM
Protecting Worksheets in Excel 2010 Help with protecting folders?? charger shop Outlook 3 04-06-2011 02:52 PM
Protecting Worksheets in Excel 2010 Protecting word documents elgell Word 1 03-25-2011 02:49 PM
Protecting Worksheets in Excel 2010 Relinking excel worksheets iffy Excel 2 01-07-2011 01:53 PM
Protecting Worksheets in Excel 2010 Protecting your logo in Word TimD Word 5 04-29-2010 07:10 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:06 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft