Modify Word Font Size Cascade Options

[mstuf]

Hello - thanks for Looking

I am offered in the cascading drop down font size menu the options of size 8, 10, 12, 14 and on up. I find myself needing 6 and 7. They are valid options for the font I am using.

By Highlighting the current size and manually entering 6 or 7 and hitting enter - the requested Text size is applied to my highlighted area of my Word Document.

Can I add 6 and 7 as options to my Word XL 2002 drop cascading down menu ?

I have found VBA code to add whole menus I have searched the Tools Customize option etc but cant seem to see how to add to this menu.

Thanks for Looking -

As always -- Help much appreciated.

 

[Macropod]

Hi mstuf,

AFAIK, you can't add extra sizes to the built-in buttons; I suppose it would be possible to create a replacement one though.

However, you shouldn't need to select such font sizes on a regular basis; instead, you should be using suitably-defined paragraph and/or character Styles to achieve the desired formatting.

 

[mstuf]

Thanks for the Reply -

I am using Word and Excel to Create a Combination -- Shipping Label - Packing List - Pull Slip / Record of Order Sheet.

I needed to select those sizes 9 times today -- but usually about 3-5.

Here is the process.

I Paste the sales notification twice into a Word Template that only contains my Return address. I run a Macro that Collects buyer name and address and Moves it to a specified line of the Document, indented into the correct place so that the top part becomes my shipping label and changes the size of print for the buyer info to 18.

I then place my cursor in the appropriate spot in the document -- Change to Excel and find the SKU Number for the sale item. I run another macro that removes the row from the open excel file to the sold excel file and places a copy of the description cell into my Word Document at the postion the cursor was left in the top of the two copies of the Notification. This Creates the Packing List Portion.

The Bottom portion that remains is my sales / shipping copy.

ONLY - When Orders are international, I also then need to copy the name and address info and paste twice after the last line and size down to 8 - 7 or 6 depending on the size of the Name and Address. Some are 3 lines and simple -- Some countries regularly have 5 and 6 line addresses. The text size needed is decided when I see the Length of the Lines and the Number of them. The two small Name / Address's go on the customs declaration form that has to go to post with each international shipment.

SO...

its not on all documents.
its not always the same placement in the document. ( Line # )
Size requirement is not always the same.

My Misunderstanding of the process. When I added Auto Save to Excel 2002 by "add in" it added to the TOOLS drop down menu. I had thought additional font selections could be added the same way.

"Suitably-defined paragraph and/or character Styles" are new terms to me. I will read about them and see if they can be used in light of the conditions given above.

Sounds like it may be better to just create a Macro that highlights the name / address -- pastes it after the last line twice and changes size to standard 6 -

Thank You !! I always learn so much here.

 

[Peter_SSs]

Not exactly what you have asked for, but in Word, with your text selected try these various keyboard cominations:

Ctrl+Shift+>
Ctrl+Shift+<
Ctrl+]
Ctrl+[

 

[mstuf]

Thank You Peter -- Those are Outstanding -- and I never knew they existed.

I'm a Keystroke person anyway --

I'm so used to my routine that I fly through actions described --- and the drop down box seemed a nuisance. It will take me a few times to get acclimated but this will be fine for now. It appears that the form I receive sales notifications in may be changing soon and then I will again need to adapt my macros to still function. ( Sigh )

Good Job -- thanks

 

[Peter_SSs]

Cheers, you should quickly be able to zoom to an appropriate font size with those. You may find other useful shortcuts here, which is where I 'stole' those from after Googling.

 

[Macropod]

IMHO, properly defined Styles are still the way to go. Every paragraph-level feature in Word, including fonts, indenting alignment, etc. is tied to them. To see how to use them, check out:
http://office.microsoft.com/en-us/word-help/style-basics-in-word-HA010230882.aspx
http://www.shaunakelly.com/word/styles/tipsonstyles.html

 

[mstuf]

Thank you Peter and Paul

One issue of the Font sizeDrop down box is that when I work hurried - the box is small and the mouse placement must be accurate - sometimes the highlight and replacement digit doesnt take -- so the Keystroke combo is a nice work around and I have already used it today.

( Nice Link to more keystrokes -- some I had not seen before - thanks )


After reading just a bit, I do agree that - properly defined Styles will be the best way when I update my routine. ( I mentioned that I have been warned that a change is afoot in the sales notification format soon and that will disrupt my Macro / OLE Routine ). The properly defined Styles is a totally new concept for me. 97% of my Office Product use is spent at Excel. This is what I love about this board. I read here and Google about what I learn here while I eat or watch TV to gain some understanding of it. That way I will be familiar with it when I have to redo but not upset the routine now for its remaining days.

I come across books ( beyond basic starter books ) about excel at our shops regularly -- but I have not found anything exciting about Word. I was never a Word processor user and so I've just learned to make something work rather that using all the features correctly. Just about the time I started to advance on Office Products out Community College Extension Programs that got out here - disappeared.

Thanks for the New Idea and the Link.


As always -- This has been great