Ctrl+Home will not return to the first unprotected cell.

U

USAMax

Well-known Member
Joined
May 31, 2006
Messages
846
Office Version
  1. 365
Platform
  1. Windows
I have a sheet with heavy data validation. The sheet is also password protected so you cannot select cells that are locked. Currently A11 is the first unlocked cell in the workbook.

Why doesn't Ctrl+Home take me to A11?
 

Excel Facts

Links? Where??
If Excel says you have links but you can't find them, go to Formulas, Name Manager. Look for old links to dead workbooks & delete.
You must log in or register to reply here.

Similar threads

N
  • Question Question
Clear data displaying after a Ctrl F 'Find' search
Replies
5
Views
275
Alex Blakenburg
A
M
  • Question Question
Not running code
Replies
0
Views
191
MagicCarpet
M
N
  • Question Question
VBA - Intersect code being re-initiated
Replies
1
Views
182
Peter_SSs
Peter_SSs
GMC The Macro Man
  • Question Question
Sorting a table in a protected sheet when some cells are locked -MACRO needed
Replies
3
Views
344
RoryA
RoryA
N
  • Question Question
Locking a row after info entered
Replies
1
Views
752
RustamMika
R

Forum statistics

Threads
1,223,227
Messages
6,170,849
Members
452,361
Latest member
d3ad3y3

Share this page

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