View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Terry Pinnell[_4_] Terry Pinnell[_4_] is offline
external usenet poster
 
Posts: 192
Default Change default settings for Comments?

GS wrote:

If I add a comment to a cell using Excel 365, the default displays my
name at the top, and it's also in a larger font than I'd like. How
can I permanently change those settings please?


Comments have been that way for as long as I can remember. I just hold
down the Backspace key and hit Ctrl+B to remove boldface.

The font is whatever you have set up to be your pref for 'Normal'.

J-Walk's books have a section devoted to the Comment object. You could
look there for a VBA solution that runs in place of the default
procedure when you click 'Insert Comment'!


Thanks Garry, I'll look into that. (I'm currently refreshing myself on
the basics with the opening chapters of John Walkenbach's 'Excel 2000
Programming for Dummies' ;-)

But meanwhile I've written a trivial MX macro, 'Add Comment' which
just opens a comment box in the selected cell and backspaces out the
redundant name.

It's activated by <Ctrl + Shift + M. Choosing a KB shortcut for VBA
macros is always an issue, both to avoid conflicts and ambiguity. I
have so many assigned to MX macros, some of which are global, i.e. not
'scoped' to a specific program or window. And Excel's repertoire is
rather limited (no Alt, Win or Function keys, for instance).

--
Terry, East Grinstead, UK