Hi
In the Editor project explorer window double click the ThisWorkbook
module. In the dropdown on the top left where it says (General), choose
the Workbook option. The shell of the Workbook_Open macro should
appear.
Now simply put Userform1.Show in this sub and the userform will show
when you open the workbook.
regards
Paul

Bafa wrote:
When I start my Excel file I have to choose tools/macros/visual basic
editor and the open Userform1 and choose to run it. How can I make my
file user friendly for my co-workers by having them open my file and
instantly have the UserForm appear?


--
Bafa
------------------------------------------------------------------------
Bafa's Profile: http://www.excelforum.com/member.php...o&userid=37748
View this thread: http://www.excelforum.com/showthread...hreadid=573686