how to turn buttons into floating objects

%3CLINGO-SUB%20id%3D%22lingo-sub-1405122%22%20slang%3D%22en-US%22%3Ehow%20to%20turn%20buttons%20into%20floating%20objects%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1405122%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSPAN%3EGood%20Morning%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3EI%20have%20several%20%22shapes%22%20that%20serve%20as%20buttons%20that%20allow%20me%20to%20move%20from%20leaf%20to%20leaf%2C%20like%20the%20left%20side%20menu.%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3EThis%20sheet%20also%20has%20fixed%20panels%2C%20which%20help%20me%20to%20control%20the%20information%20that%20must%20always%20be%20visible.%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3EWhen%20you%20scroll%20down%20the%20page%2C%20the%20shapes%20that%20serve%20as%20menus%20also%20scroll.%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%20class%3D%22%22%3EIs%20there%20a%20way%20for%20these%20menu%20buttons%20to%20be%20floating%20and%20always%20visible%20to%20the%20user%3F%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3EAttached%20I%20put%20an%20example%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3EThank%20you%20for%20your%20help%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1405122%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1405283%22%20slang%3D%22en-US%22%3ERe%3A%20how%20to%20turn%20buttons%20into%20floating%20objects%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1405283%22%20slang%3D%22en-US%22%3E%3CP%3E-ERR%3AREF-NOT-FOUND-%40Carlos_Soares%26nbsp%3B%3C%2FP%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThere%20is%20no%20VBA%20code%20to%20detect%20a%20scroll%20down%20event.%20So%20basically%20there%20is%20no%20easy%20way%20to%20do%20what%20you%20require.%20However%20if%20you%20know%20some%20advanced%20VBA%20techniques%20there%20is%20a%20page%20below%20where%20you%20can%20find%20some%20instructions%20to%20detect%20this.%20To%20change%20the%20location%20of%20the%20shapes%20you%20need%20to%20change%20the%20%22Top%22%20property%20of%20the%20shape%20according%20to%20the%20scroll%20height.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22http%3A%2F%2Fwww.cpearson.com%2Fexcel%2FDetectScroll.htm%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttp%3A%2F%2Fwww.cpearson.com%2Fexcel%2FDetectScroll.htm%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Contributor

Good Morning
I have several "shapes" that serve as buttons that allow me to move from leaf to leaf, like the left side menu.
This sheet also has fixed panels, which help me to control the information that must always be visible.
When you scroll down the page, the shapes that serve as menus also scroll.
Is there a way for these menu buttons to be floating and always visible to the user?

Attached I put an example

Thank you for your help

1 Reply
Highlighted

@Carlos_Soares 

Hello,

 

There is no VBA code to detect a scroll down event. So basically there is no easy way to do what you require. However if you know some advanced VBA techniques there is a page below where you can find some instructions to detect this. To change the location of the shapes you need to change the "Top" property of the shape according to the scroll height.

 

http://www.cpearson.com/excel/DetectScroll.htm