+ Reply to Thread
Results 1 to 2 of 2

VBA code crashes Excel 365 but works in Excel 2019

  1. #1
    Registered User
    Join Date
    10-05-2018
    Location
    Milan
    MS-Off Ver
    2019
    Posts
    34

    VBA code crashes Excel 365 but works in Excel 2019

    Hi guys,
    first of all forgive my English.

    I have this file that when I use it at home with my Excel 2019 everything works fine as expected, when I use it at work with Excel 365 it crashes after a few seconds.
    It seems to me that the problem is in the code below (in the sheet "GIACENZA MONETA"), so I'd really appreciate your help to fix it.

    This code does 2 things:
    1. when the user changes a cell, it updates the date and time in cell F25
    2. when the user writes something in cell F3, it makes it upper case and adds the word "cassa " on the left (if the word "cassa" has not been written by the user).

    I think there must be a conflict of some sort that makes Excel 365 crash (it just closes without any warnings this file I'm using and also other Excel files that could be open).

    I've attached the file here, it's password-protected by a simple " " (space).

    Please Login or Register  to view this content.
    Thank you for your time and effort.

    Matteo
    Italy
    Last edited by Matt7272; 02-04-2021 at 12:56 PM.

  2. #2
    Registered User
    Join Date
    06-08-2021
    Location
    Frick, Swityerland
    MS-Off Ver
    2010
    Posts
    1

    Re: VBA code crashes Excel 365 but works in Excel 2019

    Hello Matteo, did you find the reason of the crash ? I have exactly the same problem now.

+ 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. Macro filter date works in Excel 2010 and not in 2019
    By Berna11 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-28-2020, 07:11 PM
  2. macro works in excel 2019 but not in 2010 this gives type mismatch error 13
    By Newbikonob1 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-20-2019, 06:25 AM
  3. Replies: 4
    Last Post: 09-01-2017, 04:09 PM
  4. Code works in Windows excel 2003 and 2010 but crashes in Mac excel 2011
    By kiweed in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-19-2012, 08:46 PM
  5. [SOLVED] Userform1 runs, all code works as it is required, but when i close it, Excel crashes
    By Spyderz in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 10-28-2012, 02:34 PM
  6. [SOLVED] Macro works but crashes Excel 2010
    By Willardio in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 10-09-2012, 08:49 AM
  7. Code Crashes Excel 2010 but works in Excel 2003
    By aaronf316 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-07-2011, 03:46 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