View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Excel Monkey[_2_] Excel Monkey[_2_] is offline
external usenet poster
 
Posts: 36
Default Code not saving in Class Module

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


"Excel Monkey" wrote:

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