Thanks for the response, Tom.

But as I mentioned earlier, for the first run I get the run-time error
Programmatic access to VB Project is not trusted, and for subsequen
runs of the sub, I get the run-time error: Method 'VBProject' of objec
'_Workbook' failed.

Is it something to do with my local setting that I get these run-tim
errors....?

My macro security setting is set to 'Medium'. And I am using Windows X
professional and Office XP.

Manges

--
mangesh_yada
-----------------------------------------------------------------------
mangesh_yadav's Profile: http://www.excelforum.com/member.php...fo&userid=1047
View this thread: http://www.excelforum.com/showthread.php?threadid=27309