ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   HOW DO I KEEP DRAWING OBJECTS ANCHORED? (https://www.excelbanter.com/excel-discussion-misc-queries/26968-how-do-i-keep-drawing-objects-anchored.html)

HOW DO I KEEP DRAWING OBJECTS ANCHORED?

HOW DO I KEEP DRAWING OBJECTS ANCHORED?
 
I'VE ASSIGNED A MACRO TO A DRAWING OBJECT AND THE OBJECT I WOULD LIKE TO KEEP
VISIBLE AS I SCROLL DOWN THE SHEET. MUCH LIKE COLUMN HEADINGS WHEN THE
FREEZE PANES SELECTION IS USED.

Dave Peterson

I think I'd either put those objects in Row 1 and then use freeze panes so that
row 1 is always visible.

Another alternative would be to create a floating toolbar and use that.

HOW DO I KEEP DRAWING OBJECTS ANCHORED? wrote:

I'VE ASSIGNED A MACRO TO A DRAWING OBJECT AND THE OBJECT I WOULD LIKE TO KEEP
VISIBLE AS I SCROLL DOWN THE SHEET. MUCH LIKE COLUMN HEADINGS WHEN THE
FREEZE PANES SELECTION IS USED.


--

Dave Peterson


All times are GMT +1. The time now is 11:44 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com