Thread: [Solved] Limit cell range use
View Single Post
 
Old 12-28-2010, 10:32 AM
BjornS BjornS is offline Windows Vista Office 2003
Competent Performer
 
Join Date: Jan 2010
Location: Sweden
Posts: 116
BjornS is on a distinguished road
Default

Hi,
try this (Excel 2003):
(sorry for any incorrect translation, I am using a Swedish Excel version).

Mark the cells you want to use (for example A1:G20)
Select menu: Format / Cells. Click the tab "Protection". Unclick the checkbox "Locked".

To make this choice active (the "Locked" you did above), you must now protect the whole sheet.
Select menu: Tools / Protection / Protect sheet.
Before pressing "OK", unclick the checkbox "Mark locked cells".

Kind regards
Bjorn
Reply With Quote