+ Reply to Thread
Results 1 to 1 of 1

Command Button vs ActiveX Button Causing System Resource Drain

  1. #1
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    7,022

    Command Button vs ActiveX Button Causing System Resource Drain

    .
    Initially I believed the problem was due to setting a number of workbook sheets to xlSheetVeryHidden vs. xlSheetHidden.

    After further experimentation I discovered what is actually causing the issue is the use of Command Buttons vs ActiveX Buttons.

    I have approx. 11 Command Buttons in use on various sheets within the workbook. They all function as expected - no issue. After
    pasting the 12th Command Button on a new sheet ... the problem started. When attempting to assign a macro to the Command Button
    the computer goes into a wait state (spinning blue circle indicating the system is doing something), then after 15 seconds of so, Excel
    crashes. This occurs no matter how many times I attempt to assign a macro to that 12th button.

    I just tried using an ActiveX button to replace the Command Button ... NO PROBLEMS !

    Does anyone have any ideas why this is occurring ? I always understood ActiveX buttons were more prone to issues.


    ?????

    Thank you for looking.
    Last edited by Logit; 02-13-2019 at 01:54 PM.

+ 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. Not Enought System Resources
    By Hippy in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-27-2012, 02:52 AM
  2. not enough system resources
    By StrawberryFields in forum Excel General
    Replies: 2
    Last Post: 07-13-2011, 07:18 PM
  3. Excel use of system resources
    By klanch in forum Excel General
    Replies: 3
    Last Post: 08-24-2010, 05:22 PM
  4. Excel 2007 : Not enough system resources
    By JPlunket in forum Excel General
    Replies: 0
    Last Post: 01-14-2010, 10:33 PM
  5. Not enough system resources
    By akabraha in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-15-2007, 07:38 PM
  6. Not enough system resources to display completely.
    By randys in forum Excel General
    Replies: 5
    Last Post: 01-12-2006, 09:00 AM
  7. Not Enough System Resources
    By Erika in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-19-2005, 11:13 PM
  8. [SOLVED] Not enough system resources to display completly
    By mark in forum Excel General
    Replies: 2
    Last Post: 01-19-2005, 01:46 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