|
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. |
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. |
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. |
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. |
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. |
| All times are GMT +1. The time now is 02:49 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com