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

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.
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?
 
Upvote 0

Forum statistics

Threads
1,214,648
Messages
6,120,726
Members
448,987
Latest member
marion_davis

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
Back
Top