RB Smissaert Wrote:
It sound there is a missing reference.
Look in the VBE under Tools, References.
Maybe you need to save the workbook without the reference and add it in
code
in the Workbook_Open event.

This is correct. It was the referance to Adobe Distiller that is used
in another program that is causing this error. Now I need to know how
to fix it.

A later program that I use turns the sheet into a PDF and then e-mails
it, hence the referance, but I don't have to have that enabled until
after this particular button is pressed. Once this button is pressed,
it is sent to our computers which all have acrobat loaded on them.
How would I go about loading a referance via a macro?


--
wilro85
------------------------------------------------------------------------
wilro85's Profile: http://www.excelforum.com/member.php...o&userid=26935
View this thread: http://www.excelforum.com/showthread...hreadid=562641