Prevent cells selected in Excel 2003 worksheet

AAAAndy

New Member
Joined
Feb 1, 2010
Messages
27
I used to use a method in Excel 2003 where I protect a sheet and the user cannot select any cells except the ones I specify. Not that they can't CHANGE or EDIT the cell, but it doesn't allow them to even SELECT the cell.

Does anybody know how? And also, is there a similar method in Excel 2007?
Thanks!
 

Excel Facts

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the $ sign).

AAAAndy

New Member
Joined
Feb 1, 2010
Messages
27
OK, I got it! Format the cells you want to ALLOW the user to change as Unlocked. Select Tools - Protection - Allow Users to Edit Ranges.
Add the ranges they are allowed to change. Then go to Tools - Protection - Protect Sheet and uncheck the box next to Select locked cells. Keep the box checked next to Select UNlocked cells.

This works only slightly different in Excel 2007.

This cost me a beer for a good friend.
Andy
 

JoeMo

MrExcel MVP
Joined
May 26, 2009
Messages
17,753
Office Version
  1. 365
  2. 2010
Platform
  1. Windows
I used to use a method in Excel 2003 where I protect a sheet and the user cannot select any cells except the ones I specify. Not that they can't CHANGE or EDIT the cell, but it doesn't allow them to even SELECT the cell.

Does anybody know how? And also, is there a similar method in Excel 2007?
Thanks!
Unlock the cells you want the user to have access to, then protect the sheet.
In Excel 2007, when you protect the sheet you will get a dialog box that allows you to select various options. One option is to allow the user to select a locked cell. Remove the check from this option to prevent selecting all locked cells.
 

AAAAndy

New Member
Joined
Feb 1, 2010
Messages
27
Thanks, Joe. As you see I got the answer. Sorry - but you're too late for the beer.
 

AAAAndy

New Member
Joined
Feb 1, 2010
Messages
27
Whoops! Yes, Joe, I got the same solution, I just wrote it wrong in my posting. Yours is written correctly. Thanks.
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,151,857
Messages
5,766,791
Members
425,379
Latest member
thedoctor00

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