Edit Box in Excel

[triad1234]

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

 

[xlbo]

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