Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Advanced Excel Template Help...

Status
Not open for further replies.

sirach

IS-IT--Management
Jun 28, 2002
15
US
I created a Fax Cover Sheet template in Excel 2000. I created various cells into which a user can enter data and I have locked the rest of the cells so they can't change the template. A user is able to tab through the various cells into which they enter data, but the last cell isn't a cell at all, it's a tex box. This is where the user enter's the notes on the fax cover sheet. Is there a way to ensure the text box is in the TAB order when a user is tabbing through the cells. Currently, it wraps from the last cell to the first cell and skips the text box entirely. We are trying to eliminate the need for mouse clicks to allow us to create fax cover sheets faster, without having to reach for the mouse. It's a silly question, but I thought someone might know.

Thanks!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top