Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Feb 2008
    LOUISVILLE, Kentucky, USA
    Thanked 0 Times in 0 Posts

    Old code no longer works, why?

    I have been using this code for over a year and a half now and it worked perfectly fine.
    now for some reason it does not work.
    the part that is not working any longer is the ignore caps...
    I need it to reflect any type of letter (caps on or off)

    please advise...
    [rivate Sub Workbook_Open()
    Dim strValue As String
    Dim Sht As Worksheets, foundSheet As Boolean, TEMPLATE As String
    Dim rng As Range
    Dim iRow As Long
    Dim myDate As Date, newDate As Date, oldSheet As String, newSheet As String
    Dim WS As Worksheet

    Application.ScreenUpdating = False
    Set WS = Sheets("job held data entry")
    Application.ScreenUpdating = True
    Application.SpellingOptions.IgnoreCaps = True
    end sub
    Last edited by CROSSFYRE2; 2011-06-07 at 06:34.

  2. #2
    Star Lounger
    Join Date
    Jun 2010
    Lichfield, UK
    Thanked 0 Times in 0 Posts
    What OS and version of Excel are you using?

    I've just created a new xlsm file, copied your VBA into the Worksheet.Open event and entered some data containing proper words and misspelt words in both lowercase and all uppercase.

    With Application.SpellingOptions.IgnoreCaps = True then the SpellChecker does not pick up the misspelt words if they are all uppercase. If it is False then the spell checker does pick them up. Is that the behaviour you used to have and are expecting?

    I'm on XP SP3 and Excel 2007 SP2 (version of EXCEL.EXE is 12.0.6557.5000 which I think is SP2 plus a few updates).

Posting Permissions

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