All my text box disappear.
 

Hi I am currently doing some work on excel 2003 and suddenly all my textbox
disappear. I can no longer use the textbox function. Please help. I have a
lot of information written in textbox. Thanks.

Answer: All my text box disappear.
 

Hi there! I'm sorry to hear that you're having trouble with your text boxes in Excel 2003. Here are some steps you can try to troubleshoot the issue:

1. Check if the text boxes are hidden: Sometimes, text boxes can accidentally get hidden behind other objects or cells. To check if this is the case, go to the "Home" tab and click on "Find & Select" in the "Editing" group. Then, select "Go To Special" and choose "Objects" from the list. This will select all the objects in your worksheet, including any hidden text boxes. If you see any selected objects that are not visible, right-click on them and choose "Format Object". Then, go to the "Properties" tab and uncheck the "Hidden" option.
   
2. Check if the text boxes are on a hidden sheet: It's possible that your text boxes are on a sheet that is hidden. To check if this is the case, right-click on any sheet tab at the bottom of the Excel window and choose "Unhide". If you see any hidden sheets in the list, select the one that you think might have the text boxes and click "OK". If you find the sheet with the text boxes, you can unhide it permanently by right-clicking on its tab and choosing "Unhide" again.
   
3. Check if the text boxes are on a protected sheet: If your worksheet is protected, it's possible that the text boxes are locked and cannot be edited. To check if this is the case, go to the "Review" tab and click on "Protect Sheet" in the "Changes" group. If the "Text boxes" option is unchecked, it means that text boxes are not allowed on the protected sheet. You can unprotect the sheet by entering the password (if there is one) and then checking the "Text boxes" option.
   
4. Check if the text boxes are corrupted: If none of the above steps work, it's possible that the text boxes are corrupted. To check if this is the case, create a new worksheet and insert a new text box. If the new text box works fine, it means that the old ones are indeed corrupted. Unfortunately, there is no easy way to recover corrupted text boxes, so you will need to recreate them manually.

I hope these steps help you resolve the issue with your text boxes in Excel 2003. Let me know if you have any other questions or concerns!

All my text box disappear.
 

Maybe you hit the key combination
Ctrl 6

This will hide/show objects (It is a toggle shortcut)

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm




"Hwee" wrote in message ...
Hi I am currently doing some work on excel 2003 and suddenly all my textbox
disappear. I can no longer use the textbox function. Please help. I have a
lot of information written in textbox. Thanks.