Sir Babydum GBE
12-04-2012, 05:57 AM
I recorded/wrote a whole load of code on one of my office PCs
I exported the code to a central drive, imported it to the personal.xls workbook of another PC.
SO the code on the 2nd PC is identical.
On PC1 Screenupdating = FALSE works fine
On PC2 it doesn't work at all
So I record a test macro on PC2 in a new module, and switch screenupdating off succesfully. But when I run the imported macros, doesn't work.
Next step I deleted the modules from personal on PC2. Created fresh modules, and copied the text from the saved modules into the new modules. Still no joy
The code works fine, it does everything it's supposed to - except slower because of the screenupdates being visible
What's going on?
=========================================================================== ===========
Edit: I Just noticed that PC1 is running Excel 2003 (no sevice Pack) and Visual Basic 6.3. PC2 is running Excel 2003 SP3 and Visual Basic 6.5. Could this be making the difference?
I exported the code to a central drive, imported it to the personal.xls workbook of another PC.
SO the code on the 2nd PC is identical.
On PC1 Screenupdating = FALSE works fine
On PC2 it doesn't work at all
So I record a test macro on PC2 in a new module, and switch screenupdating off succesfully. But when I run the imported macros, doesn't work.
Next step I deleted the modules from personal on PC2. Created fresh modules, and copied the text from the saved modules into the new modules. Still no joy
The code works fine, it does everything it's supposed to - except slower because of the screenupdates being visible
What's going on?
=========================================================================== ===========
Edit: I Just noticed that PC1 is running Excel 2003 (no sevice Pack) and Visual Basic 6.3. PC2 is running Excel 2003 SP3 and Visual Basic 6.5. Could this be making the difference?