Esteemed Forum Participants and Lurkers:
Excel 2003 VBA
I want to throw a simple Command Button on a particular worksheet to Call a Macro for that sheet. I do not want the macro button on the tool bar - just on the one sheet.
I have the button operating and the position of the button is set "Free Floating", but the position is dependend on the SHEET. So, if I scroll the sheet, the button moves also. Is there any simple way to reference the SHEET-SPECIFIC Button position to the WINDOW so that the position is independent of the sheet? That way it should stay put always visible in one location in the window. I did a search on the forum, but I didn't find anything relevant.
Thank you for any and all comments, suggestions, and assistance.