Mystery text box I can't edit

G

Guest

Hi everyone,
I'm working on a spreadsheet that someone else has developed.
When certain cells have the focus, a text box appears next to the cells
which contain instructions on what to enter into the cells. I need to edit
these boxes, but I can't select them and nothing happens when I right click
on them. They look a little like comment boxes or text boxes, but only
appear when the cells they are associated with have the focus and not on
roll-over. Also they cannot be edited in the review facility and there is no
mention of them in the VB code.
I'm sure someone out there knows what these are. If so, please help.
Thanks
Gill
 
G

Guest

Have a look at tools>protection to see if the sheet is protected. Also there
might be a hidden sheet so check format>sheet>unhide
--
John
MOS Master Instructor Office 2000, 2002 & 2003
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)
 
G

Guest

Hi John,
Thanks, but that's not it. I've removed the protection and unhidden all the
sheets. I've also copied and pasted one of the cells in question into a new,
blank workbook and the text box thing goes with it. If anyone wants to see
what I'm talking about it I could email it over.
Gill
 
D

Dave Peterson

Check Data|Validation|Input Message Tab.
Hi everyone,
I'm working on a spreadsheet that someone else has developed.
When certain cells have the focus, a text box appears next to the cells
which contain instructions on what to enter into the cells. I need to edit
these boxes, but I can't select them and nothing happens when I right click
on them. They look a little like comment boxes or text boxes, but only
appear when the cells they are associated with have the focus and not on
roll-over. Also they cannot be edited in the review facility and there is no
mention of them in the VB code.
I'm sure someone out there knows what these are. If so, please help.
Thanks
Gill
Click to expand...
 
G

Guest

Hi John,
Thanks, but that's not it. I have unprotected the sheet and unhidden all
hidden sheets. I have even copied one of the cells into a new workbook and
the text box thing comes with it.
Anyone else any ideas??
Gill
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Text Box in Excel for noddy users! 6
edit box formatting 1
Edit text box in 2010 - how? 1
Can I protect data in a cell, but allow comments to be entered. 6
Changing Text To Numbers ? 1
text to col with embedded mystery box 5
How do I fill a text box with colour? 2
Make text cells and combo boxes required? 2

Top