Button on the taskbar

[Enkay100]

Hi ev'rybody.
I've a workbook written with vba for excel 2000. In the open event a form is shown while the application is set to not visible.
It works perfectly except for a problem I cannot figure out.
As the application is not visible, (only the form is shown on the desktop), there's no label (button) on the taskbar so, if I open another application (e.g. the internet), I can't retrieve my form any longer.
I tried with the standard vb property "showintaskbar" but it doesn't seem to work in vba.
So here's my question: does anybody know a way to have my workbook (or a reference to the form) shown in the taskbar even though it's not visible?
Thanks in advance for your suggestions.
Bye.
Nick

 

[rmikesmith]

Hi Nick,

This is not a trivial task. It will require using the Windows API to change the window style of your Userform. I suggest having a look at Stephen Bullen's FormFun Excel file (downloadable) for the relevant code. There will be a good deal of extra code to wade through, but these also provide good examples for future use, perhaps. His Excel page is at:

http://www.oaltd.co.uk/Excel/Default.htm

Regards,
Mike