PDA

View Full Version : Hidden Workbook - Now Cant Get Back!



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,

Bob Phillips
02-07-2012, 04:18 AM
Open Excel
Add a blank workbook
Open the VBIDE
Open your offending workbook
Go to the VBIDE
In the immediate window, set visible back to true.

smudge73
02-07-2012, 04:32 AM
Thanks! Thats a great help.