Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Excel VBA

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions

Excel VBA

Resolved · Low Priority · Version 2003

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

Mike has attended:
Excel VBA Intro Intermediate course

Excel VBA

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

For upcoming training course dates see: Pricing & availability

Reply Mon 2 Feb 2009, 15:52Trainer 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 articles

· How To Take Your Data Out Of The Shade
· Excel Macros for the Non-Programmer
· Make Things Easier In Excel With Lists
· How To Learn From Your Excel Mistakes
· Microsoft Excel Training Advanced Courses - Making Data Validation Work For You

Please browse our web site to find out more about
excel-training-courses and other Microsoft training courses.

Excel tip:

Create your own custom list on Excel 2010!

If you know how to use the auto-fill option on Excel then why not create your own customs lists?

The auto fill feature saves you time by allowing you to enter one of the list entries into a cell and then use your mouse to automatically drag the rest of the list into the cells below, above or to either side of the initial cell. When using your mouse to perform this task you will see a thin black cross appear at the bottom right hand side of the cell. Click, hold and drag to make the list appear.

Default lists include weekdays and months. To create your own list in Excel 2010 do the following;

>File
>Options
>Advanced
>Scroll right to the bottom of the page and you will see a buttom "edit custom lists", click this button
>enter your list in the list entries
>click add

Now try it out. Good luck.
>

View all Excel hints and tips