Commandbutton in the middle of the screen

[Villalobos]

Hello,

Does somebody know how to ensure the visibility of the command button in the middle of screen even if you use scroll bars?
Panes freeze is not an option.

 

[NARAYANK991]

Hi ,

This link shows one method , but also the drawback of using it ; please go through it and decide whether it is worth it :

http://www.mrexcel.com/forum/excel-questions/46443-possible-make-command-button-float.html

Narayan

 

[NARAYANK991]

Hi ,

This link shows VBA magic ; can you test it ? If not let me know.

http://www.mrexcel.com/forum/excel-...ing-worksheet-buttons-different-approach.html

Narayan

 

[Villalobos]

Hi,

In your second post the code for standard module is perfect for me.

Thank you the idea!