+ Reply to Thread
Results 1 to 4 of 4

Active Content Disabled, shuts down excel when enabled

  1. 01-10-2018, 12:43 PM #1
    kriminaal is offline
    Forum Contributor
    Join Date
    06-10-2008
    Location
    SW Ontario, Canada
    MS-Off Ver
    Excel 365
    Posts
    154

    Active Content Disabled, shuts down excel when enabled

    I was working on a new version of my pricing form.
    Yesterday everything was fine, macros were doing what they were supposed to.
    I know I deleted some that were no longer required, perhaps that messed something up.
    I can't find anything wrong though, I am not well experienced in code.
    Can someone proof this and see if it's good.
    thanks
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  2. 01-10-2018, 12:58 PM #2
    TMS is online now
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    48,194

    Re: Active Content Disabled, shuts down excel when enabled

    Looks OK to me. I can't see anything that would cause an issue. I'd move the On Error GoTo 0 outside the Select ... End Select.

    Please Login or Register  to view this content.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke

    Reply With QuoteRegister To Reply
  3. 01-10-2018, 01:49 PM #3
    kriminaal is offline
    Forum Contributor
    Join Date
    06-10-2008
    Location
    SW Ontario, Canada
    MS-Off Ver
    Excel 365
    Posts
    154

    Re: Active Content Disabled, shuts down excel when enabled

    Looks like that could be it. So far is working better
    I can enable without excel shutting down.
    Many thanks
    Reply With QuoteRegister To Reply
  4. 01-10-2018, 02:40 PM #4
    TMS is online now
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    48,194

    Re: Active Content Disabled, shuts down excel when enabled

    You're welcome. Thanks for the rep.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Hide Worksheet except 1 unless Macros/Content enabled
    By oneblondebrow in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-02-2017, 09:51 AM
  2. [SOLVED] BUG: formulas replaced by values when active content is enabled
    By mg.luis in forum Excel General
    Replies: 1
    Last Post: 12-18-2015, 11:56 AM
  3. Excel file often opens with Macros disabled though Macros & Active X controls are enabled
    By Balachan56 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-09-2015, 09:30 PM
  4. [SOLVED] Combo Box - Enabled and Disabled based on another Combo Box Entry
    By excelrequired in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 03-15-2014, 01:04 PM
  5. Text box to show network connections enabled/disabled
    By Dan27 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-07-2014, 10:04 AM
  6. Disabled Printing for Cell Content
    By dhvanis in forum Excel General
    Replies: 0
    Last Post: 12-01-2011, 11:54 AM
  7. [SOLVED] Copy enabled / Pasted disabled
    By Ben in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-30-2005, 07:10 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1