Macro will ask in a pop-up dialogue box "What size of font?". I will enter 12, then the whole worksheet will be formatted in ARIAL 12 font.
I always want the type of font to be arial... so there is no need to ask for the type, just the size. Thx
Macro will ask in a pop-up dialogue box "What size of font?". I will enter 12, then the whole worksheet will be formatted in ARIAL 12 font.
I always want the type of font to be arial... so there is no need to ask for the type, just the size. Thx
Last edited by Xx7; 06-30-2011 at 04:28 PM.
Hi Xx7, I think this will do it for you![]()
Please Login or Register to view this content.
Last edited by Mordred; 06-30-2011 at 04:15 PM.
If you're happy with someone's help, click that little star at the bottom left of their post to give them Reps.
---Keep on Coding in the Free World---
Nice... thanks! my final code below:
![]()
Please Login or Register to view this content.
I would further modify this to remove as much .Selects as possible
![]()
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks