+ Reply to Thread
Results 1 to 1 of 1

Excel 2010 crashing / Function debugging

  1. #1
    Registered User
    Join Date
    03-26-2016
    Location
    cz
    MS-Off Ver
    07/10
    Posts
    73

    Excel 2010 crashing / Function debugging

    Hello, i have made this file (see attachement)

    It uses a function called "background" created by GregM which DOES change background colors of cells - however if you copy this file and open the new copy as well (have both open) after refreshing colors (button top left or ctrl+alt+F9) the colors from one file copy to the other, which should not happen. (to see the difference you obviously have to change the colors in the time table, if you want to empty it, there are buttons for that among the colorful squares on the very right)

    The module COLORC contains the code for the function. What causes that? i suspect the fact that the sheets have the same name but i dont know how to debug it.

    on top of that, in version 2010 the files crashes very often (sometimes it offers to restart, sometimes doesnt), mostly when copying with ctrl+c ctrl+v, dragging data, or any other changes however, sometimes it also crashes on ANY change of certain cells (happened to me with numbers in setting sheet, and with the names and sometimes with a random cell in teh time table (tried it in version 2016 and that didnt have this problem) I also tried it in 2010 version on different computers but crashed as well. what could be the cause of that?

    Try it yourself if you keep playing with it for at least 10 minutes and change a lot of things and try to mess it up i guarantee itll crash

    everything important is protected, no password, so you cant mess it up hopefully
    Attached Files Attached Files

+ 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. Excel 2010 crashing on Close
    By Islwyn in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-20-2013, 09:26 AM
  2. Excel 2010 (Windows 7 Home Edition) crashing
    By micklloyd in forum Excel General
    Replies: 0
    Last Post: 07-14-2013, 01:01 AM
  3. Excel 2010 crashing when running macros....my code?
    By dietcoke802 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-20-2013, 05:56 PM
  4. [SOLVED] Excel 2010 crashing on opening a XLSM
    By SonOfOdin in forum Excel General
    Replies: 4
    Last Post: 04-18-2013, 08:05 AM
  5. Replies: 10
    Last Post: 03-13-2013, 06:15 AM
  6. Excel 2010 keeps crashing when running a specific macro.
    By bean29 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-08-2013, 07:36 AM
  7. [SOLVED] Excel 2010 crashing when closing file
    By Albatros in forum Excel General
    Replies: 4
    Last Post: 06-13-2012, 12:52 PM
  8. Macro is crashing Excel 2010
    By kahss33 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-15-2011, 10:04 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