ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Text Box Order (https://www.excelbanter.com/excel-discussion-misc-queries/129613-text-box-order.html)

Lisa U.

Text Box Order
 
I have a form I created in Excel that uses all text boxes and objects. I
need to protect the document so it will be used as an application that will
be e-mailed to customers. When I protect the document the tabbing will not
pick up some of the text boxes or objects and mixes up the order also. I
need to solidify the order I want each box to be tabbed through...ANYONE?????
Help.


[email protected]

Text Box Order
 
On Feb 7, 10:51 am, Lisa U. wrote:
I have a form I created in Excel that uses all text boxes and objects. I
need to protect the document so it will be used as an application that will
be e-mailed to customers. When I protect the document the tabbing will not
pick up some of the text boxes or objects and mixes up the order also. I
need to solidify the order I want each box to be tabbed through...ANYONE?????
Help.


Unprotect the sheet
Check that the text box properties are locked
Make sure the property for "locked text" is not checked
Click on each text box and look and see what the text box name is in
the upper left corner i.e. Text Box 1, Text Box 2, etc.
Excel should tab to the boxes in sequence of the name.
Hope that helps..
George



All times are GMT +1. The time now is 10:38 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com