Bob,

i am still having problems i have made the changes. but when i place
simple code.

Sub testr()

thisWB.Activate

End Sub

I just get object undefined. I am unsure of the class module as persum
this is what defines thisWB

I thought that the inputbox would popup once i had opened anothe
workbook. but no jo

--
Message posted from http://www.ExcelForum.com