ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Delete Display Alert tagged to an individual cell (https://www.excelbanter.com/excel-programming/276921-delete-display-alert-tagged-individual-cell.html)

Lisa[_7_]

Delete Display Alert tagged to an individual cell
 
In Excel 2000 I have a spreadsheet that seems to have a
cell with a display alert (looks like a text box) - I seem
to gather that its some sort of customized Office
Assistant. The text box can not be dragged outside the
computation area (columns and rows area) of the worksheet
unlike Office Assistant - however when I turn on the Office
Assistant and mouse over to it - the text box becomes a
bubble from the Office Assistant.

I do not need this custom feature... I do not know how it
was created and (1) like to modify the text instead to be
more applicable OR (2) DELETE it all together.

PLEASE HELP ASAP! I need to try this spreadsheet in tomorrow.
Thanks

Abdul salam

Delete Display Alert tagged to an individual cell
 
Right Click the cell and select delete comments

Abdul Salam

-----Original Message-----
In Excel 2000 I have a spreadsheet that seems to have a
cell with a display alert (looks like a text box) - I

seem
to gather that its some sort of customized Office
Assistant. The text box can not be dragged outside the
computation area (columns and rows area) of the worksheet
unlike Office Assistant - however when I turn on the

Office
Assistant and mouse over to it - the text box becomes a
bubble from the Office Assistant.

I do not need this custom feature... I do not know how it
was created and (1) like to modify the text instead to be
more applicable OR (2) DELETE it all together.

PLEASE HELP ASAP! I need to try this spreadsheet in

tomorrow.
Thanks
.


Tom Ogilvy

Delete Display Alert tagged to an individual cell
 
If there isn't a red triangle in the upper right corner of the cell (an
indication of a comment although these can be turned off) then it is
probably produced by data=validation. Select the cell and do
Data=Validation and select ClearAll or go to the tabs and modify the
message. If clearall is not offered as a button in the lower left corner of
the dialog, then it may be a comment as previously suggested.

--
Regards,
Tom Ogilvy


Lisa wrote in message
...
In Excel 2000 I have a spreadsheet that seems to have a
cell with a display alert (looks like a text box) - I seem
to gather that its some sort of customized Office
Assistant. The text box can not be dragged outside the
computation area (columns and rows area) of the worksheet
unlike Office Assistant - however when I turn on the Office
Assistant and mouse over to it - the text box becomes a
bubble from the Office Assistant.

I do not need this custom feature... I do not know how it
was created and (1) like to modify the text instead to be
more applicable OR (2) DELETE it all together.

PLEASE HELP ASAP! I need to try this spreadsheet in tomorrow.
Thanks





All times are GMT +1. The time now is 04:55 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com