+ Reply to Thread
Results 1 to 4 of 4

Excel 2007 : change fron from comic sans to wingdings

  1. #1
    Registered User
    Join Date
    02-10-2010
    Location
    UK
    MS-Off Ver
    Excel 2007
    Posts
    25

    change fron from comic sans to wingdings

    Hi

    Can someone help solve a little problem I am having?

    I keep cattle, and keep their records on a spreadsheet. I have the animal's date of birth in cell D8, a formula which automatically gives the animal's age in H8, and the date of death in M8. All of these cells are set for Comic Sans font, size 11.

    Normally cell M8 is empty, but when the animal dies, a date will be put in M8. When this happens, instead of cell H8 giving the animal's age I want it to display the cross symbol in Wingings, code 0251, in size 24. So an entry in M8 must cause the font in H8 to switch to Windings and enter Alt 0251 in size 24. Can this be done? Or can it be done another way?

    If it's relevant, the formula in cell H8 is currently =IF(D8="","",IF(DATEDIF(D8,TODAY(),"y")=0,"",DATEDIF(D8,TODAY(),"y")&"y ")&IF(DATEDIF(D8,TODAY(),"ym")=0,"",DATEDIF(D8,TODAY(),"ym")&"m ")&DATEDIF(D8,TODAY(),"md")&"d")

    btw, it's Excel 2007.

    Thanks
    Last edited by Spike0907; 02-10-2010 at 07:53 AM.

  2. #2
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,406

    Re: change fron from comic sans to wingdings

    Hi, you could use the following macro in the Sheet Change event.
    Please Login or Register  to view this content.
    Regards
    Richard Buttrey

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Registered User
    Join Date
    02-10-2010
    Location
    UK
    MS-Off Ver
    Excel 2007
    Posts
    25

    Re: change fron from comic sans to wingdings

    That is great - working fine, thanks. Rated +

    One thing, can I set it so that the security warning about macros doesn't stop the macro from working every time I open the worksheet?

  4. #4
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,406

    Re: change fron from comic sans to wingdings

    Hi,

    Only by changing the Application settings.

    Office Button>Excel Options>Trust Center>Trust Center Settings>Macro Settings and change to Enable All Macros.

    But as the note says be wary. If you open workbooks from people you don't know there's always a chance they could contain macros which do malicious things.

    Regards

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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