Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Susan
 
Posts: n/a
Default Tabbing through Unlocked cells

I have protected my spreadsheet so that users will only tab to cells that
they need to enter data into, but I have 2 problems.

In one section, when I tab from cell 16a to 17, then tab again it jumps to
16b, then back to 17, tab again to 16c, tab again it jumps again to 17, tab
again it jumps back to 16c. How do I get these to tab in sequence?

The second problem is when I have tabbed to the last cell, then tab again,
it will jump to the first 2 unlocked cells and then it won't tab to anything
else.

Susan
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I lock all cells in Excel except 2 which I need unlocked? Alex Excel Discussion (Misc queries) 1 August 18th 05 03:30 PM
Tabbing to move between cells Cassi Excel Discussion (Misc queries) 1 June 17th 05 10:59 PM
tabbing to pre-determined cells Pat S Excel Discussion (Misc queries) 1 January 16th 05 10:20 PM
Help adding text values Texas-DC_271 Excel Worksheet Functions 7 January 15th 05 11:14 PM
Convert data type of cells to Text,Number,Date and Time Kevin Excel Worksheet Functions 1 December 31st 04 12:57 PM


All times are GMT +1. The time now is 04:10 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"