Hidden Application Problem

[mouse88]

When my workbook loads I set the Application.Visible property to false. I was going to put a button in with a password to show the workbook again but closed it before doing this.

Now I have no way of being able to access the vb editor because only my user form is visible.

Anyone know how I can get around this?

I tried writing some code in a new book to create a new application, set it to visible and open the workbook but it just froze on me.

 

[Richard Schollar]

Can't you just open the workbook with macros disabled? Change your security settings if need be so that you get asked/choose disabled by default.

 

[mouse88]

Thanks didn't think of that