Excel macro works on two PCs but not on a third PC

[WaltW]

I have an Excel macro that works perfectly on two PCs but not on a third PC. All three PCs have Windows XP and MS Office 2003 installed, and all three use the identical macros and identical Excel files. What are the possible causes for the macro not to work on the third PC? Are there any settings in Excel that could affect the operation of a macro? Or is the third PC screwed up somehow? Thanks for any suggestions offered.

Walt

 

[fredericofonseca]

what happens when you try to run the macro? error messages? nothing? what about stepping trough the code? does it break in any particular point?

Just saying it doesnt work doesnt help much.

Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com

 

[WaltW]

Sorry - didn't think I needed to get into the specifics of the macro failure since it works fine on 2 of the 3 PCs. The particular macro in question is designed to do some re-formatting of an Excel sheet to make it more readable - re-formatting includes deleting blank rows and columns and doing some basic color highlighting. On the one PC where the macro fails, it successfully formats about the top 3/4 of the sheet but leaves the rest of it unformatted. No error messages appear. The initial report consists of ~100 rows. Hope that helps!

Walt

 

[Wray69]

Do all Macros not work on this third PC or is it just this one? You can try checking you Macro security settings, Tools > Macros > Security, change it to Low.

Wray

 

[KenWright]

Silly question but are you sure they are all really identical? Where are the macros stored, and have you tried taking a working file and macro from a working machine to the non-working one and trying that?

If the macro does anything at all then it's not down to security settings, and usually ina case like this the user has done something (albeit something trivial) that will break a macro, especially if the macro has no error trapping in it.

Regards
Ken............

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission
----------------------------------------------------------------------------