Results 1 to 2 of 2
  1. #1
    Star Lounger
    Join Date
    Feb 2004
    Location
    Houston, Texas, USA
    Posts
    95
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Worksheet Font Change (2000/9.0.6926 SP-3)

    What is the VBA code to change the font size for an entire worksheet? I need to do this from with an MS Project macro. I have already opened the Excel worksheet from within Project but I need to know how to select the entire worksheet. I believe the code to change the font size is fairly simply: just

    .Font.Size = 8

    Thanks,
    Caroline

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Worksheet Font Change (2000/9.0.6926 SP-3)

    Try ActiveSheet.Cells.Font.Size = 8

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •