View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] bmurphy@xlrotor.com is offline
external usenet poster
 
Posts: 49
Default Tools/Customize question - toggle Show/Hide Comments without a macro

This might be the wrong forum for this post, but if anyone knows the
answer to this, I think it will be someone in this group.

In Excel 2003 I can drag-create a button from Tools/Customize/Commands/
View/Comments

I find this button quite useful for toggling the display of comments.
However, it also makes the "Reviewing" toolbar visible when comments
are made visible, and then doesn't hide it when comments are turned
off.

Is there a way prevent the Reviewing toolbar from appearing at all, or
to hide it when comments are turned off?

The following "one-liner" is an ok workaround, but it would be really
nice to be able to do this without a macro.

Sub ShowHideComments()
Application.DisplayCommentIndicator = -1 *
Application.DisplayCommentIndicator
End Sub

Thanks,

Brian Murphy
Austin, Texas