hpw to float the uderform across worksheet ?

Hello,

I'm trying to make userform to be floating over worksheet in active workbook.
Anybody can help ?
scsong71Asked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
avidyaConnect With a Mentor Commented:
hi,

rightclick on the tab in excel choose "view programcode" (don't know exactle, have Dutch myself)

add this:

Private Sub Workbook_Open()
 Worksheets(1).ShowDataForm
End Sub
0
 
avidyaCommented:
you can make an macro called "autostart" which displays your form on opening the sheet
0
 
scsong71Author Commented:
Thanks for the advise, but how I can make my macro autostart ?
0
 
avidyaCommented:
hi scsong71,

Plaese let me know why you graded my answer a "c"
0
All Courses

From novice to tech pro — start learning today.