Excel Personal.XLB Workbook Routines not firing?

Chris K 0 Reputation points
2023-06-16T07:51:07.4766667+00:00

I have lots of modules/routine in my Personal.xlsb that I use daily and all work fine, but

Added a routine in Workbook_SheetChange and it wouldn't fire? exhausted all possible syntax errors

Tried adding one line of code to other Workbook routines and none of them will fire??

I'm working from home from a networked drive and Personal.xlsb is not visible, nor is the XLstart folder so I cant delete it

I can add modules to it and they work and save fine

Any idea how to get the Workbook routines to start firing again?

Microsoft 365 and Office | Development | Other
Microsoft 365 and Office | Excel | For business | Windows
0 comments No comments
{count} votes

3 answers

Sort by: Most helpful
  1. Olaf Helper 47,441 Reputation points
    2023-06-16T07:56:03.1033333+00:00

    https://learn.microsoft.com/en-us/answers/questions/1302553/why-doesnt-this-fire-at-all

    Again or still?

    As I wrote, it works and to validate it set a breakpoint and debug it.


  2. Chris K 0 Reputation points
    2023-06-16T12:59:22.8233333+00:00

    I dont think you read my new question:

    I "Tried adding one line of code to other Workbook routines and none of them will fire??"

    Any idea how to get the Workbook routines to start firing again?

    0 comments No comments

  3. Chris K 0 Reputation points
    2023-06-19T07:19:44.0333333+00:00

    Any ideas anyone?

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.