oh, just wanted to add it works great.

To get it to work i did have to change a setting in the "trust center". I had to place a tick mark beside
"Trust access to the VBA project object model".

Once i did that it worked fine. If i did not do that then i got a run time error.

"Programmtic access to the visual basic project is not trusted."