The 'thisWB' variable must be declared somewhere and set to a
specific workbook. Perhaps you are thinking of the built-in
object ThisWorkbook.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"pauluk " wrote in
message ...
Bob,

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

Sub testr()

thisWB.Activate

End Sub

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

I thought that the inputbox would popup once i had opened
another
workbook. but no joy


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