Quote Originally Posted by HTSCF Fareha View Post
I have been looking online for any pointers and had come across this page.

The situation decribed in that post is along the lines to the message that I am receiving "The macro can't be found or has been disabled because of your Macro security settings".
You appear to be dealing with a different (and more common) problem. I suggest posting a separate question to get the best answers.