If you are using Excel 2000 or later, you can show the form
modelessly. E.g.,
Userform1.Show vbModeless
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
"StephanieH" wrote in
message
...
I have a Userform setup to open automatically when my file is
opened. I'd
like to dock it in the upper right-hand corner and have it
visible at all
times. Right now, the user must close the Userform to make
adjustments to
the workbook, or change move from sheet to sheet. Is it
possible to leave
the Userform visible without interferring with the workbook
activity?