hi
i have a public sub in a worksheet "a" :

public sub ABC()
''blabla bla
end sub

in the same workbook i have a modal userform that on clicking one of its buttons - calls that public sub in the worksheet.

now, calling like this
worksheets("a").ABC
fails with an error (dont remember which)

but if i write :
thisworkbook.worksheets("a").ABC
- well, that's fine.......

why ?
the sub is public and in the same workbook where the call comes from.