using activeworkbook and thisworkbook.

I noticed all the code that i have on a userform using activeworkbook will relate to whatever the last active workbook was "who would have guessed hay"
Seeing thisworkbook used a lot i decided to go through the whole project and change all activeworkbook too thisworkbook.sheet1
During this i also made a few other changes that i was confident in, When i run it now it errors on the thisworkbook.sheet1.
Is this the wrong way of using thisworkbook to make sure the code always deals with the correct file. (will this ever be affected if the file goes through a Save As)
Or is it during my over conifedents that i have made a error somewhere else and the debuger is point me here cos it hates me.

Thankyou all

ThisWorkbook will always refer to the workbook containing the code.
Sheet1 is an (implicitly created) variable - it is not a property of the ThisWorkbook object. You therefore just use Sheet1 in the code, not ThisWorkbook.Sheet1 (the variable has only project level scope so it can only refer to Sheet1 in the workbook with the code.)