Then possibly, opening the workbook causes an error that halts the code.
Does the workbook being opened contain a Workbook_Open event?

--
Regards,
Tom Ogilvy

"rbekka33" wrote in message
...

hi

i have created a button on the toolbar to run the macro


--
rbekka33
------------------------------------------------------------------------
rbekka33's Profile:
http://www.excelforum.com/member.php...o&userid=14033
View this thread: http://www.excelforum.com/showthread...hreadid=263073