ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Moving for selected cells (https://www.excelbanter.com/excel-programming/381650-re-moving-selected-cells.html)

Don Guillett

Moving for selected cells
 
Protect all but the cells desired or in a more complicated series, use a
worksheet_change event
if target.address="$A$1" then range("c3").select
if target.address="$C$3" then range("d6").select
or

if target.address="$A$1" then target.offset(2,2).select

--
Don Guillett
SalesAid Software

"Xavi Temporal" wrote in message
...
Hello!

I'm creating a worksheet with a lot of protected cells, and only several
cells are available for the user. Well, I want to know if it's possible to
"guide" the user just to seleced cells, so, when someone opens the
worksheet,
the cursor would move to "first" cell (I've selected), then the user only
can
move by the sequence of cells I've defined.

Is it possible? I want a worksheet that looks like a form.

Thank you.





All times are GMT +1. The time now is 09:03 AM.

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