Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old December 31st 04, 10:20 PM
 
Posts: n/a
Default Where to stick macro to change default comment font?

I just did a search of this group to try to figure out how to change
the default comment font from bold to regular in Excel 97.

The consensus seemed to be that there is no way to change that setting
so a macro has to be used.

I don't have a clue what to do with a macro. I mean, where am I
supposed to stick it to make it work?

What I want is for the comment window to open with no author name and
no bold font.

Here's a suggested macro I found in this group:

Sub NewComment()
On Error GoTo HasComment
With ActiveCell
..AddComment.Visible = True
..Comment.Shape.Select
Selection.Font.Name = "Comic Sans MS"
Selection.Font.Size = 12
..Comment.Visible = False
End With
HasComment:
SendKeys "+{F2}"
End Sub


  #2   Report Post  
Old January 1st 05, 12:57 AM
Tom Ogilvy
 
Posts: n/a
Default

http://www.contextures.com/xlcomments03.html

or one level above:

http://www.contextures.com/xlcomments01.html

Debra Dalgleish's site

--
Regards,
Tom Ogilvy


wrote in message
oups.com...
I just did a search of this group to try to figure out how to change
the default comment font from bold to regular in Excel 97.

The consensus seemed to be that there is no way to change that setting
so a macro has to be used.

I don't have a clue what to do with a macro. I mean, where am I
supposed to stick it to make it work?

What I want is for the comment window to open with no author name and
no bold font.

Here's a suggested macro I found in this group:

Sub NewComment()
On Error GoTo HasComment
With ActiveCell
.AddComment.Visible = True
.Comment.Shape.Select
Selection.Font.Name = "Comic Sans MS"
Selection.Font.Size = 12
.Comment.Visible = False
End With
HasComment:
SendKeys "+{F2}"
End Sub





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I set default comment font Paul Matrix Excel Discussion (Misc queries) 2 December 30th 04 06:56 PM
Can I change the comment default font stp_paul Excel Discussion (Misc queries) 4 December 30th 04 04:18 PM
How do I change the default font in an EXISTING Excel workbook? Blueski Excel Discussion (Misc queries) 1 December 29th 04 10:21 PM
How do I change the default color of the tag for insert c... [email protected] Excel Discussion (Misc queries) 1 December 17th 04 11:01 PM
Changing default font in comments? philk Excel Discussion (Misc queries) 1 December 14th 04 11:03 PM


All times are GMT +1. The time now is 06:29 AM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017