Toggle comments on or off macro
 

I would would like to display comments on template sheets for new users.
However, I would also like to allow the user to toggle between show and hide
the comments using a macro attached to a button (so as they don't need to go
to Options etc). Or, is it possible to add a comment to a cell that shows
only when double clicked?

Thanks in advance for any help with the code.

--
Jim

Toggle comments on or off macro
 

You may want to take a look at using the message in Data|Validation.

It won't react to a double click, but it'll only appear when the cell is
selected--using arrows or mouse, though.

Jim G wrote:

I would would like to display comments on template sheets for new users.
However, I would also like to allow the user to toggle between show and hide
the comments using a macro attached to a button (so as they don't need to go
to Options etc). Or, is it possible to add a comment to a cell that shows
only when double clicked?

Thanks in advance for any help with the code.

--
Jim

--

Dave Peterson

Toggle comments on or off macro
 

Jim

Comments can be toggled on/off through ViewComments so no need to go all the
way into ToolsOptionsView.


Gord Dibben MS Excel MVP

On Wed, 4 Oct 2006 03:13:01 -0700, Jim G wrote:

I would would like to display comments on template sheets for new users.
However, I would also like to allow the user to toggle between show and hide
the comments using a macro attached to a button (so as they don't need to go
to Options etc). Or, is it possible to add a comment to a cell that shows
only when double clicked?

Thanks in advance for any help with the code.

Toggle comments on or off macro
 

I wanted to provide an on/off switch on the page and was hoping for a more
exotic solution, this will have to do.

Thanks you both for the prompt response.
--
Jim


"Gord Dibben" wrote:

Jim

Comments can be toggled on/off through ViewComments so no need to go all the
way into ToolsOptionsView.


Gord Dibben MS Excel MVP

On Wed, 4 Oct 2006 03:13:01 -0700, Jim G wrote:

I would would like to display comments on template sheets for new users.
However, I would also like to allow the user to toggle between show and hide
the comments using a macro attached to a button (so as they don't need to go
to Options etc). Or, is it possible to add a comment to a cell that shows
only when double clicked?

Thanks in advance for any help with the code.