ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Unknown object in a worksheet (https://www.excelbanter.com/excel-discussion-misc-queries/56743-unknown-object-worksheet.html)

Lee

Unknown object in a worksheet
 
I have a worksheet with some cells that, when selected either individually or
collectively, pop up what appears to be a comment box . . . however, it is
like a text box and it is the same text box no matter which cell is selected.
It pops up on the same location on the sheet and can be moved around by
dragging . . . it is not tied to a single cell like a comment.

I have right clicked on it and nothing happens. I have searched for macros,
objects, etc. to try to identify this object so I can get rid of it, and have
not found anything.

Does anyone have any idea what this could be or how I could find a way to
delete it?

Thank you in advance!

Don Guillett

Unknown object in a worksheet
 
try right clickcut

--
Don Guillett
SalesAid Software

"Lee" wrote in message
...
I have a worksheet with some cells that, when selected either individually
or
collectively, pop up what appears to be a comment box . . . however, it is
like a text box and it is the same text box no matter which cell is
selected.
It pops up on the same location on the sheet and can be moved around by
dragging . . . it is not tied to a single cell like a comment.

I have right clicked on it and nothing happens. I have searched for
macros,
objects, etc. to try to identify this object so I can get rid of it, and
have
not found anything.

Does anyone have any idea what this could be or how I could find a way to
delete it?

Thank you in advance!




Lee

Unknown object in a worksheet
 
when right clicking it only highlites the object as long as you hold it.
when you release the click, the object is no longer hilited. clicking or
right clicking does not 'select' the object. know what i mean?

Lee

"Don Guillett" wrote:

try right clickcut

--
Don Guillett
SalesAid Software

"Lee" wrote in message
...
I have a worksheet with some cells that, when selected either individually
or
collectively, pop up what appears to be a comment box . . . however, it is
like a text box and it is the same text box no matter which cell is
selected.
It pops up on the same location on the sheet and can be moved around by
dragging . . . it is not tied to a single cell like a comment.

I have right clicked on it and nothing happens. I have searched for
macros,
objects, etc. to try to identify this object so I can get rid of it, and
have
not found anything.

Does anyone have any idea what this could be or how I could find a way to
delete it?

Thank you in advance!





Lee

Unknown object in a worksheet
 
AHA! The 'object' was an input message from Data, Validation. Problem
solved. Just thought I would share the solution.

"Lee" wrote:

when right clicking it only highlites the object as long as you hold it.
when you release the click, the object is no longer hilited. clicking or
right clicking does not 'select' the object. know what i mean?

Lee

"Don Guillett" wrote:

try right clickcut

--
Don Guillett
SalesAid Software

"Lee" wrote in message
...
I have a worksheet with some cells that, when selected either individually
or
collectively, pop up what appears to be a comment box . . . however, it is
like a text box and it is the same text box no matter which cell is
selected.
It pops up on the same location on the sheet and can be moved around by
dragging . . . it is not tied to a single cell like a comment.

I have right clicked on it and nothing happens. I have searched for
macros,
objects, etc. to try to identify this object so I can get rid of it, and
have
not found anything.

Does anyone have any idea what this could be or how I could find a way to
delete it?

Thank you in advance!






All times are GMT +1. The time now is 08:56 PM.

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