+ Reply to Thread
Results 1 to 3 of 3

Saving VBA Code Freezes Excel

  1. #1
    Forum Contributor
    Join Date
    10-24-2012
    Location
    Chicago
    MS-Off Ver
    O365
    Posts
    311

    Saving VBA Code Freezes Excel

    Hello,

    I was wondering if anyone might know why I have the following issue?

    While I am working in VBA at about a 85% rate when I adjust code and click save it saves the code in the VBA Editor and then the Editor screen changes over to a form screen. Excel is then frozen. I have to close the editor and force a shutdown on excel. I can then reopen the file and run the edited code. The edited code runs fine. If I go back into editor and continue to work on code the issue occurs again when saving. It is extremely annoying. I am not sure if it is due to something in my current code causing a conflict or I need IT to look at my PC?

    Regards,

    Anthony

  2. #2
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,644
    Anthony

    Is this only happening with one particular workbook?
    If posting code please use code tags, see here.

  3. #3
    Forum Contributor
    Join Date
    10-24-2012
    Location
    Chicago
    MS-Off Ver
    O365
    Posts
    311

    Re: Saving VBA Code Freezes Excel

    I have been working on building out a template workbook for a bunch of staff to use. I have only been working in this one file with code recently. I think it is outside of just the one file so I guess it is a system issue and not code?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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