For this example, I change it to Print as shown in picture below. Now you can change it to the name as you want. The VB code will be saved under the Module that can be used on any sheet under this workbookĪfter you done with VB code and come back the Excel Sheet, a name of the button still shows the default name given by MS Excel. A Microsoft Visual Basic for Applications will open as shown below.Drag and place the button on Excel sheet.Select a Button icon from the Form Controls section.Under the Developer Menu, click Insert icon.This How To will show the step by step below. We just need to add the VB code under the click event for this button. Some time we need a short cut to print the current screen by using just one click.
It will print an active screen on current sheet after you click on Print button. In this How To, I will show how to create a Print button to print current screen. How to Create a Print button to print a screen
