Excel VBA

Resolved · Low Priority · Version 2003

Thu 22 Jan 2009, 15:53 Delegate Mike said...

Mike has attended:
Excel VBA Intro Intermediate course

Excel VBA

What is VB code to hide the gridlines on a worksheet?

Mon 2 Feb 2009, 15:52 Trainer Carlos said...

RE: Excel VBA

Hi Mike

To hide the gridlines on a sheet the code line is

ActiveWindow.DisplayGridlines = False

Replacing False with True displays hidden grid lines

The ActiveWndow object in this case refers to the active sheet.

You may need to precede it with a

Sheets(SheetName).Select

if the present sheet isn't the one losing the grid lines

Hop this helps

Carlos

Mon 9 Feb 2009: Automatically marked as resolved.

Excel tip:

Create own ribbon tab - Excel 2010

a. In Excel click on the File tab
b. Select Options from left hand side
c. Choose the Customize Ribbon section
d. Click the New Tab button (below the list of tabs on the right hand side of the dialog box)
e. Select the New Tab (Custom) and enter a name, by clicking the Rename button (below the list of tabs on the right hand side of the dialog box)
f. Select the New Group (Custom) and enter a name, by clicking the Rename button (below the list of tabs on the right hand side of the dialog box)
g. Add commands to your tab and group by locating them on the list on the right hand side (remembering that you can change the list using the drop down box at the top of the list of commands) and clicking the Add button between the two panes to add them to your tab and group
h. You can rearrange the commands in your group, the groups on any tab or the tabs, using the up and down arrow buttons beside the list of tabs.
i. Click OK to apply your changes

View all Excel hints and tips

Excel VBA

Excel VBA

RE: Excel VBA

Excel articles

Excel tip:

Create own ribbon tab - Excel 2010