Docking Pivottable toolbar in Excel

[Guest]

Can anyone tell me how to dock the pivottable toolbar in Excel so that
refreshing or updating a pivottable won't move it? I wrote a macro to lock
the "standard" toolbar, the "formatting" toolbar and the "pivottable" toolbar
and it appeared to work fine (i.e. I couldn't move them with the mouse).
However, when I refresh data in my pivottables it undocks the pivottable
toolbar and puts it on top of the spreadsheet (the behavior that annoyed me
to begin with), and since I locked the toolbars I can't move the pivottable
toolbar that is sitting on top of the worksheet. I had to write another
macro to unlock the toolbars so I could move the pivottable toolbar off the
spreadsheet and dock it at the top again.

This problem has annoyed me for years and I've finally gotten frustrated
enough to try to solve it.

 

[Guest]

If you mean to dock it with the standard toolbars at the top of the screen,
you double click on the top of the toolbar and it will dock.

 

[Guest]

Gary, thanks for your response. It didn't totally answer my question of how
to keep the toolbar from undocking when the pivottable was updated, but it
did help. I was manually dragging the toolbar back to the top to dock it
again. I didn't realize you could just double click on the top of the
toolbar to dock it again. That makes the problem a little less frustrating.
Thanks.