Try this:

Go to menu: Tools- Macro- Visual Basic Editor
(or use shortcut key: ALT+F11)

In your editor now go to menu: Tools- References...
Upon clicking 'References...' , References - MenuToolbar box wil
pop-up.

In Available references, uncheck those all boxes which names star
with
'Missing' and click button OK.

Try running your macro again and see whether helps.

Cheers
ilyaskaz

--
ilyaskaz
-----------------------------------------------------------------------
ilyaskazi's Profile: http://www.excelforum.com/member.php...fo&userid=2396
View this thread: http://www.excelforum.com/showthread.php?threadid=56508