disable non selection area

khokon

New Member
Joined
Jan 20, 2005
Messages
1
dear sir, i wnat A1 to C1 and A10 to c10 make a table. and other range make disable. no body can click other range, i mean without unselect range



Thnaks
khokon
 

Excel Facts

When they said...
When they said you are going to "Excel at life", they meant you "will be doing Excel your whole life".

vconfused

Well-known Member
Joined
Jun 11, 2004
Messages
547
What version of Excel are you working with? If using something before Excel 2002, then you will not be able to keep people from clicking on cells, but you can protect them so people cannot make changes to them. If you are trying to keep people from seeing formulas, perhaps a workaround would be to place the formulas on another sheet, hide the sheet, and protect the workbook.

If you are using Excel 2002 or 2003 and are trying to keep people from clicking on cells outside of A1:C1,A10:C10, then you can select A1:C1, go to Format->Cells, Protection tab, uncheck locked, click OK, select A10:C10, go to Foramt->Cells, Protection tab, uncheck locked, click OK. Then protect the sheet.

Does this help at all?
 

Forum statistics

Threads
1,148,526
Messages
5,747,211
Members
424,068
Latest member
Salim khamis

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top