Hi

I've gotten it o open but only if I open the macro from
the macro open menu. How can I get it to open
automaticaly (where can I find the auto-open macro or the
workbook's open event)? Sorry for troubling you but I'm
really desperate, I have to get this done in a couple of
hours, and I've spent 90% time trying to get the program
to open automaticaly, or to open at all (the whole point
of it is so employees won't have to use macros).
Thanks
-----Original Message-----
Peter,

You need a macro to show the userform. It could be called
from the auto-open macro or the workbook's open event.

Sub ShowUserform()
Load Userform1
Userform1.Show
End Sub

Change 'Userform1' to the name of your userform.

HTH,
Bernie
Excel MVP


"Peter Baranya" wrote in
message ...
Hi
I'd really need some help with Exel. I've written a
Userform using the Visual Basic program of Exel. My
Problem is that I can't seem to display it in my
Workbook. It's a menu that allows the user to select
languages to wiew the sheet with the use of buttons.
I'd
like it to come up whenever anyone opens the workbook,
or
display this box in one of the sheets. I'd really
appreciate any help.


Thanks a lot
Newt





.