Re: Does recording a macro increase the font size?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance



Hi Diane:

A recorded macro stores only "what you do". If you did not explicitly set
the font and its size while recording, that information will not be stored,
and the result will appear in whatever font is under the insertion point
when the macro begins.

The macro does not store mouse movements: you have to move using the cursor
keys if you want to store this in a macro.

And, I think you are getting a little confused between "Returns" and
"Paragraph marks". A Paragraph mark stores font and spacing information, a
Return does not. Which one were you using?

I would follow Suzanne's suggestion: make it an AutoText (or a template). A
macro is not the simplest way to do this. You "could" do it with a macro,
but it's complicated.

Regards


On 28/3/06 2:09 AM, in article
E19FA068-6B9C-42B0-88A3-ED416371DA05@xxxxxxxxxxxxx, "Diane R."
<DianeR@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

I created a letterhead at the top of a blank document so that it could be
used for emailing purposes (instead of printing on actual letterhead just
create a letter on this and it's ready to email). I widened the left/right
margins; changed the top/bottom margins; put the company name within a one
row/one column table so that the bottom line is the only line showing; went
below that table, changed the size and superscripted the font to put in the
address and telephone numbers; put a return; changed the font back to the
original size and unchecked the superscript; inserted a continuous page
break, and added one more return. Now I've been asked to make it a macro.
I'm using the fonts that I used when I just put it on a document but when I'm
recording it for the macro the font is enlarged by 3-4 sizes. Why?

--

Please reply to the newsgroup to maintain the thread. Please do not email
me unless I ask you to.

John McGhie <john@xxxxxxxxxxx>
Microsoft MVP, Word and Word for Macintosh. Consultant Technical Writer
Sydney, Australia +61 (0) 4 1209 1410

.



Relevant Pages

  • Re: Mail Merge Label Macro w/Russian Text
    ... When I simply run a mail merge in word without recording it as a macro, ... I modify the macro to prompt the user for an excel file to read from ... and font in word appear to be working properly. ... does not support the Unicode Cyrillic characters. ...
    (microsoft.public.word.mailmerge.fields)
  • Re: inserting a tick
    ... look in the Wingdings font. ... A CheckIt macro and an UncheckIt macro. ... Checked Box and Unchecked Box AutoText entries (these are just Wingdings ... EQ field," but you can get the same effect by applying a border ...
    (microsoft.public.word.docmanagement)
  • RE: Repetive Formatting/Creating a Toolbar button
    ... and what is the scrip for the macro that will make font Arial,Bold, and have ... I work on different worksheets all of the time and have to choose format (on ... different cells specific font withing the cell). ...
    (microsoft.public.excel.misc)
  • RE: Specify a font from a formula?
    ... to resort to a macro, as it just opens up other complications for the ... The actual font I'm using is a specialty font (not Wingings; ... compact the width of the cell) but I've managed to work around it. ... character and it converts it to Wingdings and then ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Symbol Characters
    ... The macro to "unprotect" the symbols is only necessary if symbols from ... >>Word can't tell which characters are in some symbol font. ... >>Sub SymbolsUnprotect() ...
    (microsoft.public.word.vba.customization)