ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I create a macro button and place anywhere on my sheet? (https://www.excelbanter.com/excel-discussion-misc-queries/4279-how-do-i-create-macro-button-place-anywhere-my-sheet.html)

Vell H. Holcombe, P.E.

How do I create a macro button and place anywhere on my sheet?
 
I am converting from 123 and have always placed macro buttons where they
would be in view at the appropriate place in the spreadsheet.

Dave O

From the top menu, click View Toolbars Forms. When the box appears,
click the 4th box in the top row ("Button"), position the cursor on the
spreadsheet, and left-click while you drag the cursor to indicate the
size of the button (this can be adjusted later). Then a window should
appear that prompts you to assign a macro to that button.



All times are GMT +1. The time now is 06:52 PM.

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