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. |
All times are GMT +1. The time now is 02:28 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com