Excel toolbar commands

[Lori]

Just upgraded to Excel 2003 and can't find the gridline command to drag to my
toolbar - can anyone point me in the right direction. It's buried in the
tools>options>view menu. The older version let me put the command on my
toolbar.

 

[Duke Carey]

I use the following code to CLEAR gridlines. It resides in personal.xls and
is attached to a custom toolbar button.

Sub ClearGridlines()
ActiveWindow.DisplayGridlines = False
End Sub

If you want a toggle you could use:
Sub ToggleGridlines()
ActiveWindow.DisplayGridlines = not ActiveWindow.DisplayGridlines
End Sub

 

[Peo Sjoblom]

And if Lori wants a built in button do view>toolbars and check forms, then
drag it to the menu

--
Regards,

Peo Sjoblom

(No private emails please)

 

[Duke Carey]

Peo - how in the world did you find it there? And why in the world did
Microsoft put it there?

 

[Gord Dibben]

Duke

It has been there for several versions.

Why there??? Good question but no answer I could find or think of.

One would surmise it should be under the View or Format category.


Gord Dibben Excel MVP

 

[RagDyeR]

It's been there since at least 5.0

As to why ... I can't (don't) create and/or design any form without using
that icon.

You need to toggle it constantly to see the display mode of the form you're
designing.

It's one of the *rare* cases where I seem to be on the same track as
Redmond.
--

Regards,

RD
----------------------------------------------------------------------------
-------------------
Please keep all correspondence within the Group, so all may benefit !
----------------------------------------------------------------------------
-------------------

"Gord Dibben" <gorddibbATshawDOTca> wrote in message
Duke

It has been there for several versions.

Why there??? Good question but no answer I could find or think of.

One would surmise it should be under the View or Format category.


Gord Dibben Excel MVP

 

[Gord Dibben]

Good point RD.


Gord