You can also move the button around while it is on the edit mode (have rectangle line around). 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 tutorial has been tested with Excel 2007 and later. By using these directions you can focus your printing to one specific area. Thus, print outs of the spreadsheet can be massive. This How To will show the step by step below. These steps work in Excel 2007 or Excel 2010. 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
0 Comments
Leave a Reply. |