+ Reply to Thread
Results 1 to 3 of 3

Changing Unchanging Fonts to BOLD

  1. #1
    Forum Contributor
    Join Date
    10-17-2018
    Location
    Knoxville, TN
    MS-Off Ver
    Office 365
    Posts
    214

    Changing Unchanging Fonts to BOLD

    Attached is a partial copy of my Sudoku puzzle (again). On this copy, 6StringJazzer wrote the code on how to the lock numbers that are applied from a solvable puzzle. This works great, but on a real Sudoku those locked numbers are highlighted in BOLD and they are also locked.. On my puzzle, I have entered a few numbers that represent parts of a solvable puzzle, and once locked they can't be written over or deleted. However, I need to for those numbers to stand out from the other numbers that you would enter. The entire puzzle is the regular font, but I want these numbers to be BOLD. Then when the Clear Puzzle has been clicked on it will return the numbers back to regular font. The Lock and Clear Puzzle Button has the macros so this is where the code should be if it can be done.

    Thanks,

    Jerry
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,643

    Re: Changing Unchanging Fonts to BOLD

    Please Login or Register  to view this content.
    Please Login or Register  to view this content.
    Surround your VBA code with CODE tags e.g.;
    [CODE]your VBA code here[/CODE]
    The # button in the forum editor will apply CODE tags around your selected text.

  3. #3
    Forum Contributor
    Join Date
    10-17-2018
    Location
    Knoxville, TN
    MS-Off Ver
    Office 365
    Posts
    214

    Re: Changing Unchanging Fonts to BOLD

    Thanks, AlphaFrog, that is what I was looking for. Will give a good grade. btw, are you really using Excel 2003?

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Convert to Bold Fonts in a concatenated text
    By lts_ram in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 03-20-2016, 05:31 AM
  2. Excel 2010 changing fonts and color?
    By lostsoul65 in forum Excel General
    Replies: 3
    Last Post: 08-29-2012, 08:20 PM
  3. Selecting range of rows and columns and changing the fonts
    By adc in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-06-2011, 10:33 PM
  4. Changing fonts Macro
    By rickw in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-05-2007, 04:50 PM
  5. Changing default worksheet tab fonts
    By 1940LaSalle in forum Excel General
    Replies: 4
    Last Post: 12-29-2005, 03:30 PM
  6. Excel 2000 crashes when changing fonts.
    By Ross in forum Excel General
    Replies: 3
    Last Post: 01-21-2005, 09:06 PM
  7. changing default font/missing fonts
    By bloodgroove in forum Excel General
    Replies: 0
    Last Post: 01-11-2005, 02:51 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1