smudge73
02-07-2012, 04:05 AM
Hi all,
I'm new to VBA, and have been experimenting with User Forms. I worte some code to hide Excel on opening a file and then opening the User Form instead..
Application.Visible = False
Userform1.Show
Now when I open the file it does exactly that - opens the User Form instead. But, I need now to link up all the buttons on the form and I can't do that as I can't get back to the Excel workbook! Ahhhh! :banghead:
Any one know how to help?
Thanks,
I'm new to VBA, and have been experimenting with User Forms. I worte some code to hide Excel on opening a file and then opening the User Form instead..
Application.Visible = False
Userform1.Show
Now when I open the file it does exactly that - opens the User Form instead. But, I need now to link up all the buttons on the form and I can't do that as I can't get back to the Excel workbook! Ahhhh! :banghead:
Any one know how to help?
Thanks,