software

I would like to create hidden comments that can be viewed when clicking on a
smart tag. Does anyone know how to do that?

There are several ways that quot;hidden commentsquot; can be viewed on demand in
Excel.......one of which being the standard Comment Box which pops up when
it's cell is moused over......could you be a little more descriptive of your
needs.....how many comments?....how big, a sentence or a page or more?....

Vaya con Dios,
Chuck, CABGx3quot;scubagalquot; gt; wrote in message
...
gt; I would like to create hidden comments that can be viewed when clicking on
a
gt; smart tag. Does anyone know how to do that?
Chuck,

Thank you for responding to my question. I would like a 'smart tag'
rectangle to appear in one of the corners of the cell, which would give the
reader the choice of reading the comment or ignoring it. The comments will be
approximately 2 to 3 simple sentences.

Jillian

quot;CLRquot; wrote:

gt; There are several ways that quot;hidden commentsquot; can be viewed on demand in
gt; Excel.......one of which being the standard Comment Box which pops up when
gt; it's cell is moused over......could you be a little more descriptive of your
gt; needs.....how many comments?....how big, a sentence or a page or more?....
gt;
gt; Vaya con Dios,
gt; Chuck, CABGx3
gt;
gt;
gt; quot;scubagalquot; gt; wrote in message
gt; ...
gt; gt; I would like to create hidden comments that can be viewed when clicking on
gt; a
gt; gt; smart tag. Does anyone know how to do that?
gt;
gt;
gt;

Well, of course you realize this is not the sort of thing that Excel usually
does.....the regular comment Cob\xes usually suffice for things like
this.....but it is possible to put a small rectangle in certain cells by
using the Drawing Toolbar to create them. and those cells can be copy and
pasted to make many more cells with rectangles in them......then a macro can
be assigned to each.....those macros can be made to pop up a quot;Message boxquot;
or even a whole new sheet is necessary......Right-cick on a rectangel and
AssignMacro to tie the macro to the rectangle....

Here is some basic code that will use a Message Box.....if goes in a regular
module

Sub commentPOPup()
MsgBox quot;This is the message that Jillian wants to pop up.quot;
End Sub

Post back if you need more help....
Vaya con Dios,
Chuck, CABGx3quot;scubagalquot; gt; wrote in message
...
gt; Chuck,
gt;
gt; Thank you for responding to my question. I would like a 'smart tag'
gt; rectangle to appear in one of the corners of the cell, which would give
the
gt; reader the choice of reading the comment or ignoring it. The comments will
be
gt; approximately 2 to 3 simple sentences.
gt;
gt; Jillian
gt;
gt; quot;CLRquot; wrote:
gt;
gt; gt; There are several ways that quot;hidden commentsquot; can be viewed on demand in
gt; gt; Excel.......one of which being the standard Comment Box which pops up
when
gt; gt; it's cell is moused over......could you be a little more descriptive of
your
gt; gt; needs.....how many comments?....how big, a sentence or a page or
more?....
gt; gt;
gt; gt; Vaya con Dios,
gt; gt; Chuck, CABGx3
gt; gt;
gt; gt;
gt; gt; quot;scubagalquot; gt; wrote in message
gt; gt; ...
gt; gt; gt; I would like to create hidden comments that can be viewed when
clicking on
gt; gt; a
gt; gt; gt; smart tag. Does anyone know how to do that?
gt; gt;
gt; gt;
gt; gt;
Paste the following into your Worksheet's code.
Get back to your worksheet and double-click on cell $A$1

HTH
--
AP

'----------------------------------------------------
Private Sub Worksheet_BeforeDoubleClick( _
ByVal Target As Range, _
Cancel As Boolean)

Const MyCellAddr = quot;$A$1quot;
Dim c As Comment

If Target.Address lt;gt; MyCellAddr Then Exit Sub
For Each c In Comments
c.Visible = Not c.Visible
Next c
Cancel = True
End Sub
'--------------------------------------------------------

quot;scubagalquot; gt; a écrit dans le message de
...
gt; I would like to create hidden comments that can be viewed when clicking on
a
gt; smart tag. Does anyone know how to do that?