You only get one workbook_open event.

So you'll have to extract Bob's code and merge it into your existing
workbook_open routine.



mevetts wrote:

Hi,

I have pasted the code in, but I get an error message in Visual Basic
when I open the workbook.

It says - 'Compile error: Ambigious name detected: Workbook_Open'

Any thoughts?

--
mevetts

------------------------------------------------------------------------
mevetts's Profile: http://www.excelforum.com/member.php...o&userid=29130
View this thread: http://www.excelforum.com/showthread...hreadid=496603

--

Dave Peterson