ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   assign cell selection order in protected Excel worksheet (https://www.excelbanter.com/excel-discussion-misc-queries/20455-assign-cell-selection-order-protected-excel-worksheet.html)

tom92

assign cell selection order in protected Excel worksheet
 
How do I assign cell selection order in protected Excel worksheets?


JulieD

Hi

by default cell selection order is from top left to bottom right in a
protected sheet. AFAIK the only way to change this would be to write code
against the Worksheet_Change event which checks to see which cell you're in
an moves you to another cell.
--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"tom92" wrote in message
...
How do I assign cell selection order in protected Excel worksheets?





All times are GMT +1. The time now is 02:36 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com