If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Default font/Size in Comments Box
I'm running MS Office 2007 on a Vista Home Premium OS SP2, all WU's current,
with 2 GB of RAM. Windows defender, Spyware Doctor, MBAM, SAS. Everything's running just fine. I'd like to know if there's an easy way to format my Comments boxes (right click and select `insert comment') so that the default is not bold text with a font size of 9. I'd like to be able to set the default font to something else and the default font size to Arial. Is this possible for a hack like me? Thanks in advance...........Paul C. |
#2
|
|||
|
|||
Default font/Size in Comments Box
You could use a macro like the one from Debra Dalgleish's site:
http://www.contextures.com/xlcomments03.html#Plain Paul Calcagno wrote: I'm running MS Office 2007 on a Vista Home Premium OS SP2, all WU's current, with 2 GB of RAM. Windows defender, Spyware Doctor, MBAM, SAS. Everything's running just fine. I'd like to know if there's an easy way to format my Comments boxes (right click and select `insert comment') so that the default is not bold text with a font size of 9. I'd like to be able to set the default font to something else and the default font size to Arial. Is this possible for a hack like me? Thanks in advance...........Paul C. -- Dave Peterson |
#3
|
|||
|
|||
Default font/Size in Comments Box
Dave, unfortunately I have no idea of how to use the suggestions in the link
you sent me. I've never done any coding in Excel and don't know where to start. I did find that if I right click on a workbook there's something called `view code' which brings up a screen where I presume I can enter something but that's where my knowledge ends. Paul C. "Dave Peterson" wrote in message ... You could use a macro like the one from Debra Dalgleish's site: http://www.contextures.com/xlcomments03.html#Plain Paul Calcagno wrote: I'm running MS Office 2007 on a Vista Home Premium OS SP2, all WU's current, with 2 GB of RAM. Windows defender, Spyware Doctor, MBAM, SAS. Everything's running just fine. I'd like to know if there's an easy way to format my Comments boxes (right click and select `insert comment') so that the default is not bold text with a font size of 9. I'd like to be able to set the default font to something else and the default font size to Arial. Is this possible for a hack like me? Thanks in advance...........Paul C. -- Dave Peterson |
#4
|
|||
|
|||
Default font/Size in Comments Box
Since you're new to macros:
Debra Dalgleish has some notes how to implement macros he http://www.contextures.com/xlvba01.html David McRitchie has an intro to macros: http://www.mvps.org/dmcritchie/excel/getstarted.htm Ron de Bruin's intro to macros: http://www.rondebruin.nl/code.htm (General, Regular and Standard modules all describe the same thing.) Paul Calcagno wrote: Dave, unfortunately I have no idea of how to use the suggestions in the link you sent me. I've never done any coding in Excel and don't know where to start. I did find that if I right click on a workbook there's something called `view code' which brings up a screen where I presume I can enter something but that's where my knowledge ends. Paul C. "Dave Peterson" wrote in message ... You could use a macro like the one from Debra Dalgleish's site: http://www.contextures.com/xlcomments03.html#Plain Paul Calcagno wrote: I'm running MS Office 2007 on a Vista Home Premium OS SP2, all WU's current, with 2 GB of RAM. Windows defender, Spyware Doctor, MBAM, SAS. Everything's running just fine. I'd like to know if there's an easy way to format my Comments boxes (right click and select `insert comment') so that the default is not bold text with a font size of 9. I'd like to be able to set the default font to something else and the default font size to Arial. Is this possible for a hack like me? Thanks in advance...........Paul C. -- Dave Peterson -- Dave Peterson |
Thread Tools | |
Display Modes | |
|
|