can not delete text lokkingbox

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

text is displayed in what looks like a text box that gives the user instructions on what to input into the cell, when you highlight that cell. The cell is empty so you can inpput data. The problem is that you can not edit the box, nor can you delete the contents. It is not a comment box, and the worksheet does not have any macros in it. Does anyone know what this is and how to delete it, modify it and make new ones
 
Sounds like Data | Validation... | Input message tab

Regards

Trevor


tll said:
text is displayed in what looks like a text box that gives the user
instructions on what to input into the cell, when you highlight that cell.
The cell is empty so you can inpput data. The problem is that you can not
edit the box, nor can you delete the contents. It is not a comment box, and
the worksheet does not have any macros in it. Does anyone know what this is
and how to delete it, modify it and make new ones
 
Hi
thisn sounds like a commen. Do you have the option 'Edit comment' if
you right-click on this cell?

--
Regards
Frank Kabel
Frankfurt, Germany

tll said:
text is displayed in what looks like a text box that gives the user
instructions on what to input into the cell, when you highlight that
cell. The cell is empty so you can inpput data. The problem is that you
can not edit the box, nor can you delete the contents. It is not a
comment box, and the worksheet does not have any macros in it. Does
anyone know what this is and how to delete it, modify it and make new
ones
 

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

Back
Top