thisWB is (should be!) a global variable that gets set by application event
code when a workbook is opened. Not ThisWorkbook.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Chip Pearson" wrote in message
...
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/