May 20 2020 02:34 AM
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
May 20 2020 03:28 AM
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.