Msgbox "The gridlines are now " & sStatusįinally, you could also create a macro that makes sure the gridlines are turned on and then prints the current worksheet. You can, if desired, also get fancier with the macro so that it toggles the gridlines and displays their state. Here's an example of one that turns on the gridlines:Ī = True This could be assigned to either a shortcut key or to the Quick Access Toolbar. If you want to affect those, you might want to consider a simple macro to turn on the gridlines. Note that this approach affects all newly created worksheets or workbooks it doesn't affect any that were previously created. How you do this has been covered in other ExcelTips, such as this one: Creating Default Formatting for Workbooks and Worksheets If you want all of your future workbooks or worksheets to have the gridlines turned on by default, start by create a default workbook and worksheet that Excel will rely on when creating these. There are actually a couple of different ways you can approach this task. Kenneth wonders if there is a way to change this setting so that it is always selected. However, the gridlines check box (on the Sheet tab of the Page Setup dialog box) is not selected by default. When Kenneth prints a worksheet, 99% of the time he prefers printing it with gridlines.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |