J
JCinAK
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.
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.