Code not saving in Class Module

  • Thread starter Thread starter Excel Monkey
  • Start date Start date
E

Excel Monkey

The strangest thing is happening in my Personal.xslb folder. I make changes
to code, save it, close it and then reopen to find that the changes are not
there. This includes added user forms. The File has code in ThisWorbook,
three standard modules and a Class Module with Application Level events.

Any ideas why this would be happening?

Thanks

EM
 
For what I can tell this is whats happening:

I am in a class module being used for Application Events. The changes I am
trying to make are in two event procedures:

Private Sub App_SheetActivate(ByVal sht As Object)

and

Private Sub App_SheetDeactivate(ByVal sht As Object)

Whenever I edit the code in these procedures and hit SAVE and the Shutdown,
the revisions disappear when I reopen.

Thanks

EM
 
Ahhhhhhh. I realized that as my code was within event procedures in a class
module, I need to hit the STOP button in the VB Editor prior to making my
changes otherwise, the changes would not be saved.

Thanks

EM
 
Back
Top