Req. Video to create buttons in Excel
Can anyone furnish me related video how to create buttons in a worksheet & how to connect worksheets with the help of check buttons.
Hi i will make a video on how to use insert buttons and use macro to shift between sheets.
Thanks for your prompt reply.
Waiting for related video
You have to wait for sometime for video.
Here is the excel tutorial with pictures(photos)
To insert the button click on developer Tab
Than click on insert
Once clicked on insert you will see the buttons and other stuffs. Select Button or any other tool as per your requirement.
Once button is select you need to draw the button in excel
Once drawn button will apear as below and you can change the name of button.
Will soon update in forum regarding writing a macro to activate the buttons. The drawn button will have no use till macro is assigned to it.