![]() |
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