+ Reply to Thread
Results 1 to 7 of 7

Need help to Debug "Unable to setName property of the Font class"

  1. #1
    Registered User
    Join Date
    02-16-2017
    Location
    Spain
    MS-Off Ver
    2007
    Posts
    57

    Need help to Debug "Unable to setName property of the Font class"

    Hi,
    I have create this code for cell "K7".
    Its give ne one Debug.
    Attache the document.
    The code is:
    Please Login or Register  to view this content.
    Thank you for help.
    Regards,
    Attached Files Attached Files

  2. #2
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365 Ent Monthly Channel / Insiders Beta
    Posts
    8,911

    Re: Need help to Debug "Unable to setName property of the Font class"

    I would guess it should be "PT Sans Narrow" as the name.
    Rory

  3. #3
    Registered User
    Join Date
    02-16-2017
    Location
    Spain
    MS-Off Ver
    2007
    Posts
    57

    Re: Need help to Debug "Unable to setName property of the Font class"

    Hi rotya,
    Thank you for your time and help.
    Yes the Font.Name is "PT Sans Narrow" with double "rr".
    I have made the correction and it gives me the same error.
    Regards,

  4. #4
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365 Ent Monthly Channel / Insiders Beta
    Posts
    8,911

    Re: Need help to Debug "Unable to setName property of the Font class"

    Did you allow formatting cells when you protected the sheet?

  5. #5
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,230

    Re: Need help to Debug "Unable to setName property of the Font class"

    ...not relevant....
    Good Luck
    I don't presume to know what I am doing, however, just like you, I too started somewhere...
    One-day, One-problem at a time!!!
    If you feel I have helped, please click on the star to left of post [Add Reputation]
    Also....add a comment if you like!!!!
    And remember...Mark Thread as Solved.
    Excel Forum Rocks!!!

  6. #6
    Forum Expert torachan's Avatar
    Join Date
    12-27-2012
    Location
    market harborough, england
    MS-Off Ver
    Excel 2010
    Posts
    4,304

    Re: Need help to Debug "Unable to setName property of the Font class"

    "PT Sans Narrow" does not appear in MS standard available fonts (Excel 2010).
    Try with another type name.

  7. #7
    Registered User
    Join Date
    02-16-2017
    Location
    Spain
    MS-Off Ver
    2007
    Posts
    57

    Re: Need help to Debug "Unable to setName property of the Font class"

    Dear torachan, sintek and rorya,
    I have solved the problem. I forgot to apply "Unprotect Sheet".
    Please Login or Register  to view this content.
    Now is working properly.
    Regards to all.

+ 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. Pivot Table - "unable to get the pivottable property of worksheet class"
    By Pete.T in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-14-2017, 04:19 AM
  2. Getting "Unable to set CurrentPage property of PivotField class" error
    By jsweez24 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-06-2015, 03:03 PM
  3. Error 1004 - "Unable to get the CountIf property of the WorksheetFunction class"
    By kknb0800 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 01-27-2015, 12:41 AM
  4. Coming a debug "unable to get the OLEObjects property of the worksheet class
    By HaroonSid in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 05-07-2014, 02:33 AM
  5. Replies: 6
    Last Post: 01-04-2013, 11:36 AM
  6. "Unable to set the Hidden property of the Range class" when unhiding cells
    By Kaigi in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-30-2009, 03:33 PM
  7. Replies: 2
    Last Post: 08-23-2006, 12:00 AM

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