| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I change the defult settings for my comments in Excell?
This is a shared worksheet and comment font is extreamly small and when ever
we create a new comment or enter new information into an exsisting comment the font defults to the tiny font. I need to know how to change the defult setting for the comments on both Excell 2003 and Excell 2007. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I change the defult settings for my comments in Excell?
You can't do that in Excel. You need to change in windows and you really
don't want to do that cuz it probably changes more than you want throughout your computer. So, use some kind of macro like for each c in activesheet.comments c.shape.textframe.characters.font.size=14 next c -- Don Guillett Microsoft MVP Excel SalesAid Software "Delta Tango" <Delta wrote in message ... This is a shared worksheet and comment font is extreamly small and when ever we create a new comment or enter new information into an exsisting comment the font defults to the tiny font. I need to know how to change the defult setting for the comments on both Excell 2003 and Excell 2007. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I change the defult settings for my comments in Excell?
Thanks for the macro. It corected all of my existing comments. Although when
I create a new comment that font remains small. is there a way that I can get the macro to run automaticly when ever a comment is created? "Don Guillett" wrote: You can't do that in Excel. You need to change in windows and you really don't want to do that cuz it probably changes more than you want throughout your computer. So, use some kind of macro like for each c in activesheet.comments c.shape.textframe.characters.font.size=14 next c -- Don Guillett Microsoft MVP Excel SalesAid Software "Delta Tango" <Delta wrote in message ... This is a shared worksheet and comment font is extreamly small and when ever we create a new comment or enter new information into an exsisting comment the font defults to the tiny font. I need to know how to change the defult setting for the comments on both Excell 2003 and Excell 2007. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I change the defult settings for my comments in Excell?
Hi Don,
I had a friend tell that I should loot at my Zoom seting in the work book. My zoom was set to 70% when I changed it back to 100% the font was back to normal size. I think this might be the same issue that other people are having with there workbooks. Thanks for the Macro though. Delta Tango "Don Guillett" wrote: How about a macro that creates the comment and changes the font? -- Don Guillett Microsoft MVP Excel SalesAid Software "Delta Tango" wrote in message ... Thanks for the macro. It corected all of my existing comments. Although when I create a new comment that font remains small. is there a way that I can get the macro to run automaticly when ever a comment is created? "Don Guillett" wrote: You can't do that in Excel. You need to change in windows and you really don't want to do that cuz it probably changes more than you want throughout your computer. So, use some kind of macro like for each c in activesheet.comments c.shape.textframe.characters.font.size=14 next c -- Don Guillett Microsoft MVP Excel SalesAid Software "Delta Tango" <Delta wrote in message ... This is a shared worksheet and comment font is extreamly small and when ever we create a new comment or enter new information into an exsisting comment the font defults to the tiny font. I need to know how to change the defult setting for the comments on both Excell 2003 and Excell 2007. |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I change the defult settings for my comments in Excell?
http://j-walk.com/ss/excel/usertips/tip075.htm
-- Don Guillett Microsoft MVP Excel SalesAid Software "Delta Tango" wrote in message ... Hi Don, I had a friend tell that I should loot at my Zoom seting in the work book. My zoom was set to 70% when I changed it back to 100% the font was back to normal size. I think this might be the same issue that other people are having with there workbooks. Thanks for the Macro though. Delta Tango "Don Guillett" wrote: How about a macro that creates the comment and changes the font? -- Don Guillett Microsoft MVP Excel SalesAid Software "Delta Tango" wrote in message ... Thanks for the macro. It corected all of my existing comments. Although when I create a new comment that font remains small. is there a way that I can get the macro to run automaticly when ever a comment is created? "Don Guillett" wrote: You can't do that in Excel. You need to change in windows and you really don't want to do that cuz it probably changes more than you want throughout your computer. So, use some kind of macro like for each c in activesheet.comments c.shape.textframe.characters.font.size=14 next c -- Don Guillett Microsoft MVP Excel SalesAid Software "Delta Tango" <Delta wrote in message ... This is a shared worksheet and comment font is extreamly small and when ever we create a new comment or enter new information into an exsisting comment the font defults to the tiny font. I need to know how to change the defult setting for the comments on both Excell 2003 and Excell 2007. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hyperlink defult font | Excel Discussion (Misc queries) | |||
| how do I change default settings for Comments (its font, etc.) | Excel Discussion (Misc queries) | |||
| How can i hide comments given in Excell sheet | Excel Discussion (Misc queries) | |||
| Cell Comments randomly move and resize regardless of settings | Excel Discussion (Misc queries) | |||
| How to you lockout the comments in Excell from other users? | Excel Discussion (Misc queries) | |||
Linear Mode
