Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Locking Pivottable Toolbar in Excel
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating a PivotTable w/o selecting data in an existing PivotTable | Excel Discussion (Misc queries) | |||
locking formula in cells in without locking whole sheet | Excel Discussion (Misc queries) | |||
Locking column width - upon refresh of PivotTable | Setting up and Configuration of Excel | |||
PivotTable toolbar, Formulas, Calculated Item | Excel Discussion (Misc queries) | |||
PivotTable toolbar missing? | Setting up and Configuration of Excel |