Setting cell selections in form spreadsheet

K

kentuckyjo

I am trying to get my tab button to jump to the unlocked cells only so that
the user can go straight to the cells that they need to populate on my form
created in Excel. Can anyone help?
 
G

Gord Dibben

Lock all cells except the ones you want to Tab into.

Protect the worksheet.

Tabbing will move you across then down then across.

If not in that order post back.


Gord Dibben MS Excel MVP
 

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

Similar Threads

Add additional information to excel form after original data entry 0
Dealing with the error: unable to filter on excel hc home school 0
Need Help with Macro Security 1
Quick Parts / SharePoint Library Update 0
Optionbutton Not working 3
Crating User Form to Add Names 1
Request Form - Alert Team Member 0
Word macro that can call cells out of Excel for a find and replace 0

Top