Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Code not saving in Class Module
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Code not saving in Class Module
This is driving me nuts. Why is this happening?
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Code not saving in Class Module
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 "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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
CLASS MODULE & SIMPLE MODULE | Excel Discussion (Misc queries) | |||
Class Module vs Normal Module | Excel Programming | |||
Class Module? | Excel Programming | |||
Class Module | Excel Programming | |||
Variable from a sheet module in a class module in XL XP | Excel Programming |