Taborder with unlocked cells in protected worksheets

  • Thread starter Thread starter PO
  • Start date Start date
P

PO

Excel 2003, sp2

Hi,

When you lock cells in a worksheet you can jump between the unlocked cells
using the TAB key. Is there any way to influence the tab order (without
having to use a lot of code)?

Regards
Pete
 
When using the unlocked cells method your order can only be left to right and
top to bottom.

There are other methods...........one of which is using a named range with no
protection.

See Bob Phillips' site for this method.

http://www.xldynamic.com/source/xld.xlFAQ0008.html

Other methods would use VBA code.


Gord Dibben MS Excel MVP
 
You must log in or register to reply here.

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

Protect locked cells (only) from formatting? 4
unlocked cells 1
Excel crashes with protected worksheet and hidden columns? 0
Unlocking Cells 6
Protect worksheet format 1
Windows 7 Autofit row heights of merged cells in protected worksheet 0
Excel Cell Protection not Working 3
Protect worksheet but still be able to use Data Filter and Data Sort 2

Back
Top