A userform does not have a setfocus method. Why do you need to know if the focus is there?
I don't really understand. If you don't show the form modelessly, the user can't touch the sheet at all.
You may be able to simply protect the sheet using the userinterfaceonly:=true argument which will allow your code to do (almost) anything it needs to without allowing the users to change anything themselves.