essentially I just want to know how to keep a userform focused on a workbook that might have a changing name. if there are multiple workbooks open, the userform must interact only with the workbook it was intended. if the name never changed it would be as simple as setting workbooks("filename.xls").active for each action on the userform, but "filename.xls" may change to anything. so i need to get the workbook name when the userform initializes:

Dim wkb As Workbook
Set wkb = ActiveWorkbook

and then use:

workbooks(wkb).active

but the first part has to be done only in the initialization sub (so that it sets wkb to the correct workbook -- the one that initializes the form) and the other part in the other subs. but i am having trouble sending the variable wkb from one sub to another. is there an easier approach? more efficient?