Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Ctrl Home disabled in protected worksheets
I have created a workbook with a number of worksheets, each of which has a
number of locked cells and for which protection is enabled to prevent users from accessing locked cells. The top row, with the column headings, is protected. I have noticed that the control + home function to go to cell A1 seems to be disabled. How can I re-enable it? (I am running Excel 2003). |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Ctrl Home disabled in protected worksheets
When you protect the workbook, are you allowing users to select locked cells?
This would need to be enabled for Ctrl+Home to work, since A1 is locked. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Rod from B.C. Government" wrote: I have created a workbook with a number of worksheets, each of which has a number of locked cells and for which protection is enabled to prevent users from accessing locked cells. The top row, with the column headings, is protected. I have noticed that the control + home function to go to cell A1 seems to be disabled. How can I re-enable it? (I am running Excel 2003). |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Ctrl Home disabled in protected worksheets
No, I don't want the users to be able to select locked cells.
I did, however, try unlocking just cell A1, and it still didn't unlock. I would appreciate any other suggestions you might have. Thanks! "Luke M" wrote: When you protect the workbook, are you allowing users to select locked cells? This would need to be enabled for Ctrl+Home to work, since A1 is locked. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Rod from B.C. Government" wrote: I have created a workbook with a number of worksheets, each of which has a number of locked cells and for which protection is enabled to prevent users from accessing locked cells. The top row, with the column headings, is protected. I have noticed that the control + home function to go to cell A1 seems to be disabled. How can I re-enable it? (I am running Excel 2003). |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Ctrl Home disabled in protected worksheets
You may have misunderstood Luke's suggestion - by allowing users to select
locked cells doesn't mean they can change the content (as it's locked!), but it will allow the user to place the cursor in the cell. The other posible reason that Ctrl+Home will not work:- do you have 'freeze pane' applied to your worksheet? "Rod from B.C. Government" wrote: No, I don't want the users to be able to select locked cells. I did, however, try unlocking just cell A1, and it still didn't unlock. I would appreciate any other suggestions you might have. Thanks! "Luke M" wrote: When you protect the workbook, are you allowing users to select locked cells? This would need to be enabled for Ctrl+Home to work, since A1 is locked. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Rod from B.C. Government" wrote: I have created a workbook with a number of worksheets, each of which has a number of locked cells and for which protection is enabled to prevent users from accessing locked cells. The top row, with the column headings, is protected. I have noticed that the control + home function to go to cell A1 seems to be disabled. How can I re-enable it? (I am running Excel 2003). |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Ctrl Home disabled in protected worksheets
You are right, Ron; I did misunderstand. I didn't realize that a locked cell
prevents users from changing the contents, but having just run a quick test I see that you are of course right. Problem solved! Thanks, Luke and Ron, for your help! "Ron@Buy" wrote: You may have misunderstood Luke's suggestion - by allowing users to select locked cells doesn't mean they can change the content (as it's locked!), but it will allow the user to place the cursor in the cell. The other posible reason that Ctrl+Home will not work:- do you have 'freeze pane' applied to your worksheet? "Rod from B.C. Government" wrote: No, I don't want the users to be able to select locked cells. I did, however, try unlocking just cell A1, and it still didn't unlock. I would appreciate any other suggestions you might have. Thanks! "Luke M" wrote: When you protect the workbook, are you allowing users to select locked cells? This would need to be enabled for Ctrl+Home to work, since A1 is locked. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Rod from B.C. Government" wrote: I have created a workbook with a number of worksheets, each of which has a number of locked cells and for which protection is enabled to prevent users from accessing locked cells. The top row, with the column headings, is protected. I have noticed that the control + home function to go to cell A1 seems to be disabled. How can I re-enable it? (I am running Excel 2003). |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Ctrl Home disabled in protected worksheets
Glad we could help.
Thanks for the feed back Ron "Rod from B.C. Government" wrote: You are right, Ron; I did misunderstand. I didn't realize that a locked cell prevents users from changing the contents, but having just run a quick test I see that you are of course right. Problem solved! Thanks, Luke and Ron, for your help! "Ron@Buy" wrote: You may have misunderstood Luke's suggestion - by allowing users to select locked cells doesn't mean they can change the content (as it's locked!), but it will allow the user to place the cursor in the cell. The other posible reason that Ctrl+Home will not work:- do you have 'freeze pane' applied to your worksheet? "Rod from B.C. Government" wrote: No, I don't want the users to be able to select locked cells. I did, however, try unlocking just cell A1, and it still didn't unlock. I would appreciate any other suggestions you might have. Thanks! "Luke M" wrote: When you protect the workbook, are you allowing users to select locked cells? This would need to be enabled for Ctrl+Home to work, since A1 is locked. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Rod from B.C. Government" wrote: I have created a workbook with a number of worksheets, each of which has a number of locked cells and for which protection is enabled to prevent users from accessing locked cells. The top row, with the column headings, is protected. I have noticed that the control + home function to go to cell A1 seems to be disabled. How can I re-enable it? (I am running Excel 2003). |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Ctrl/Home changes the Zoom | Excel Discussion (Misc queries) | |||
Ctrl+Home is not A1 | Excel Worksheet Functions | |||
Excel 2007: Ctrl+PgUp or Ctrl+PgDn with Protected Sheets | Excel Discussion (Misc queries) | |||
Ctrl+Home failure when sheet protected | Excel Discussion (Misc queries) | |||
Ctrl + Home stopped working | Excel Discussion (Misc queries) |