Toppers

Hiya. clear2 is just a macro which clears my current sheet of any data,
I should have taken it out.

The workbook has a userform which automatically appears whenever you
open the workbook up. I want to stop this automatically happening as in
this macro I am changing between workbooks.

Hope that makes sense.

I didn't post the whole macro in.