#1   Report Post  
Old July 8th 08, 06:43 PM posted to microsoft.public.excel.setup
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2008
Posts: 2
Default Comment Default Format

I can't see how to change the default behaviour when a new Comment is started.
I want the default format for a new comment to be a different font face and
font size.

  #2   Report Post  
Old July 8th 08, 07:24 PM posted to microsoft.public.excel.setup
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 22,908
Default Comment Default Format

You can change the default font size only........

Right-click on the desktop, and choose Properties
On the Appearance tab, click Advanced.
From the Item dropdown, choose Tooltip
Choose a font Size, click OK, click OK

To change font type you need VBA code

http://www.contextures.on.ca/xlcomme...html#Formatted


Gord Dibben MS Excel MVP


On Tue, 8 Jul 2008 10:43:00 -0700,
wrote:

I can't see how to change the default behaviour when a new Comment is started.
I want the default format for a new comment to be a different font face and
font size.


  #3   Report Post  
Old July 8th 08, 07:36 PM posted to microsoft.public.excel.setup
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2008
Posts: 2
Default Comment Default Format

Thanks much. A fairly obscure location for the change! I'm glad you knew
where it was.

"Gord Dibben" wrote:

You can change the default font size only........

Right-click on the desktop, and choose Properties
On the Appearance tab, click Advanced.
From the Item dropdown, choose Tooltip
Choose a font Size, click OK, click OK

To change font type you need VBA code

http://www.contextures.on.ca/xlcomme...html#Formatted


Gord Dibben MS Excel MVP


On Tue, 8 Jul 2008 10:43:00 -0700,
wrote:

I can't see how to change the default behaviour when a new Comment is started.
I want the default format for a new comment to be a different font face and
font size.





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 the default comment format and view in Excel Lady G Excel Discussion (Misc queries) 1 May 27th 07 05:38 AM
How do i format a default comment Trainman Excel Worksheet Functions 1 February 28th 07 03:57 PM
Change default format for 'Comment' pm brown Excel Discussion (Misc queries) 2 March 29th 06 10:48 AM
How do I set up the default format for a comment? Gitesh Excel Discussion (Misc queries) 1 April 1st 05 11:18 PM
How do I change the default format for a comment? L4dy_L33l00 Excel Discussion (Misc queries) 1 January 7th 05 01:22 AM


All times are GMT +1. The time now is 05:49 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017