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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Edit Box in Excel

Status
Not open for further replies.

triad1234

MIS
Nov 14, 2003
19
US
Hi All,

Does anybody know why edit box icon(ab|) grayed after you select View->TOOLBARS->FORMS in Excel? How can you turn it on? I use this feature a lot especially in tables with Microsoft Word and turn protection on document after I finished to leave only ab| fields to be allowed to fill in.
I would like to do the same thing in Excel.

Thanks in advance for any tips,

Rob
 
Protection etc works very differently in excel compared to Word. You can protect or unprotect individual cells so there is no need to use this textbox approach. I guess the reason they are not available is that every cell, is, in effect a textbox. Note - you should be able to use the "Controls Toolbox" textbox however....

Rgds, Geoff

"Errors have been made....Others will be blamed"

Please read FAQ222-2244 before you ask a question
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top