Shared Workbook and Taskbar Behavior

  • Thread starter Thread starter DanH
  • Start date Start date
D

DanH

After opening multiple workbooks then opening a workbook
that is shared all of the Multiple Workbooks appear as one
on the taskbar. Only after clicking tools-> options ->
windows in taskbar is selected will all workbooks will
appear in the taskbar. Why does this happen and how can it
be STOPPED?????
 
Hi--I tried creating the fix below and keep getting a
compiling error. Since I am new to VB maybe I am making
some little mistake. I followed the steps as outlined and
cut and pasted the macros written here, but keep
getting "User Defined Type not Defined". Any ideas what
I'm doing wrong?

Deb Borys
(e-mail address removed)
 
I think you're going to have to help more.

Which one did you run?

And where did the error occur?

Post the code (not the workbook) and indicate the line that caused the damage.

I did see one thing that I missed in my post:

After you create the Class module, it'll be called Class1
click on that class1
hit F4
In the (name) box, change the name from Class1 to WinInTaskBar

(If that was the fix, sorry about the missing portion.)

But that wasn't the error I got when before I renamed it.
 
Thanks, Dave, that was the missing piece. Sorry I wasn't
more specific in my request, but you nailed it anyway.
That makes you mighty!! (Sorry, been watching my Firefly
DVDs lately.)

Seriously, I appreciated the help tremendously. This was
annoying the hell out of me.

Deb Borys
(e-mail address removed)
 
Back
Top