Hi All,

Thanks for your valuable suggestions and questions.
The version of excel is 2003 and OS is WinXP SP2.
The VBAproject is protect by password. In VBA project properties there's a tab for protection and that person put a password there. When I click on VBAproject it prompts for password.
Usually it is not the policy to put a password on macro. But may be the macro also contains password for some important systems as it runs a BW report also and this guy put it so that end user of the report can't see them. And as he was a contractor so before leaving he forget to tell to anyone.
Now I need to change the BW query so I want to see first what macro is exactly doing and does my change going to make an impact on its working.

Cheers