Thread: [Solved] Protection in Excel
View Single Post
 
Old 02-28-2013, 06:35 AM
OTPM OTPM is offline Windows 7 32bit Office 2010 32bit
Expert
 
Join Date: Apr 2011
Location: West Midlands
Posts: 981
OTPM is on a distinguished road
Default

Hi
Have you tried protecting the cells you dont want changed?
To do this:
1. Select the whole worksheet and untick the protect cells tick box.
2. Select those cells that you want to protect.
3. Re-tick the protect cells tick box.
4. Protect the worksheet and add a pasword if you wish.
This should provide you with what you want.
Good luck.
Tony
Reply With Quote