Posted by Luke on November 14, 2001 1:33 PM
I have had a problem come up using codenames.
I have an almost completely VBA run program. Using this I also add sheets and work with them. The odd thing now is, I discovered; that I cannot use the codename to identify the new sheet. Old sheets work just fine, activesheet.name is recognized in the new sheet, but activesheet.codename is not (it is with earlier sheets). The really odd thing is that when I turn on the VBA editor, the problem is gone, turn it off and there is the problem again with jet when I create a new sheet. It was like trying to fine the problem with the ilghts off, but with a lot of catchhooks I found it. I have altered the entire code to use activesheet.name, but I really would have like to use the codename in order to be able to play with the name. Can anybody tell me what the problem may be??? and how to solve it. Some of the things I started using just before I discovered the problem are calculationmanual or -automatic and enableevents true/false. I don't have a previous version anymore since The entire program seemed to work fine (more that a half year already but I never had to create a new sheet like I did now)