Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Two instance of same VBAProject....
Hi,
I'm getting some strange thing with my spreadsheet with fair bit of VBA. I close it (not exiting Excel), then open up the same sheet again or another spreadsheet, i have an instance of the closed spreadsheet VBAProject in VB Editor like as if it is open (ie, I can go into it and edit, but it won't save.). My main problem is that this instance of the closed spreadsheet affected the re-open spreadsheet (Some of the code that was excuting probably, won't execute probably if the closed spreadsheet instance). I remembered reading somewhere that this got something to do with VBA, ie the way you coded. IS this true? IF it is, does anyone know the causes? I read Michael Tatlow's "VB Editor in 2003", I didn't install Goggle desktop search engine. Thanks Augustus |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VBAProject | Excel Worksheet Functions | |||
VBAProject Scope | Excel Programming | |||
VBAProject Scope | Excel Programming | |||
How to get rid of a VBAProject? | Excel Programming | |||
code in VBAProject will not run | Excel Programming |