Hidden Excel

[ro55co]

Need a bit of help here i created a macro to hide excel when a button is clicked. Unfortunetly i have hidden excel and then closed the userform which has the button on it to unhide excel. Does anyone know a way of getting excel to reappear.

[Macdave_19]

What do you mean you've hidden excel? you mean the entire window (as in its not even in the task bar?).

and secondly why???

[royUK]

Need a bit of help here i created a macro to hide excel when a button is clicked. Unfortunetly i have hidden excel and then closed the userform which has the button on it to unhide excel. Does anyone know a way of getting excel to reappear.

I take it you have used Application.Hide.

This sort of event is exactly why I would advise people not to do such things, along with changing users' settings. I think you will need to abandon that instance of Excel by using Ctrl+Alt+Delete.

Just consider what would happen if your program did this to the end user, maybe even your boss!

[ro55co]

Hey i managed to fix it just by openning another saved excel file and it used the same instance of excel making it visible again (maybe should have tryed that first). Its ok ma boss just laughed at me

[colaiuta]

Hi!

Another approach would probably be to use Ctrl+Break to stop the macro, and then goto to the VBA editor (Alt+F11), open the immediate window (Ctrl+G) and type "application.hide = false"