This will insert a rectangle shape in the worksheet. You will notice that your cursor changes to a plus icon In Shapes options, click on the Rectangle option.In the illustrations group, click on Shapes.You can easily insert a shape (square or rectangle) and can make it look like a button.Īnd since it’s a shape, you can easily format it to look perfect with your existing formatting or brand colors.īelow are the steps to insert a shape in Excel: I personally love this method and prefer it over the rest two methods covered later. While there are dedicated buttons that you can insert in the worksheet and then assign the macro to it, I will first cover how to assign a macro to a shape. Insert a Shape and Assign Macro to that Shape Assign a Macro to an ActiveX Control Button.Keeping Shape Visible When you Hide/Resize Rows/Columns.Insert a Shape and Assign Macro to that Shape.
0 Comments
Leave a Reply. |