How do I direct cursor to a specific cell?

  • Thread starter Thread starter Sandman
  • Start date Start date
S

Sandman

In Microsoft Excel - Upon completion of entry in cell F4 I want cursor to go
to cell E6; then to H4; then to G6, etc.
 
You could use a worksheet_change event in the sheet module
if target.address="$F$4" then range("e6").select
etc
 
Select the cell you want to enter data into, click FORMAT in the menu and
select FORMAT CELLS. Click the PROTECTION tab in the dialog box and remove
the check from the LOCKED check box.

Click OK to exit.

Once you're back in the worksheet, click TOOLS in the menu and select
PROTECT SHEET. Remove the check mark from SELECT LOCKED CELLS and if you want
to add a password.

Click OK to exit.

Now the only cells that are tabbed to are the ones you unprotected earlier.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top