thanks for all your help.

I moved the scrollbar instructions to the top of the list and everything
works

NickHK wrote:
Remove the On Error Resume Next to see the real cause of the error.
Hint: Is a CommandBar a member of the ActiveWindow ?

NickHK

Well, the plot thickens...

[quoted text clipped - 9 lines]
I have a copy of Office 2007 but have been hesitant to install it due to all
complaints about running slow or crashing when macros are run.

--
Message posted via http://www.officekb.com