Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Excel toolbar commands
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 toolsoptionsview menu. The older version let me put the command on my toolbar. |
#2
|
|||
|
|||
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 "Lori" wrote: 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 toolsoptionsview menu. The older version let me put the command on my toolbar. |
#3
|
|||
|
|||
And if Lori wants a built in button do viewtoolbars and check forms, then
drag it to the menu -- Regards, Peo Sjoblom (No private emails please) "Duke Carey" wrote in message ... 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 "Lori" wrote: 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 toolsoptionsview menu. The older version let me put the command on my toolbar. |
#4
|
|||
|
|||
Peo - how in the world did you find it there? And why in the world did
Microsoft put it there? "Peo Sjoblom" wrote: And if Lori wants a built in button do viewtoolbars and check forms, then drag it to the menu -- Regards, Peo Sjoblom (No private emails please) "Duke Carey" wrote in message ... 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 "Lori" wrote: 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 toolsoptionsview menu. The older version let me put the command on my toolbar. |
#5
|
|||
|
|||
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 On Fri, 2 Sep 2005 10:55:04 -0700, "Duke Carey" wrote: Peo - how in the world did you find it there? And why in the world did Microsoft put it there? "Peo Sjoblom" wrote: And if Lori wants a built in button do viewtoolbars and check forms, then drag it to the menu -- Regards, Peo Sjoblom (No private emails please) "Duke Carey" wrote in message ... 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 "Lori" wrote: 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 toolsoptionsview menu. The older version let me put the command on my toolbar. |
#6
|
|||
|
|||
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 On Fri, 2 Sep 2005 10:55:04 -0700, "Duke Carey" wrote: Peo - how in the world did you find it there? And why in the world did Microsoft put it there? "Peo Sjoblom" wrote: And if Lori wants a built in button do viewtoolbars and check forms, then drag it to the menu -- Regards, Peo Sjoblom (No private emails please) "Duke Carey" wrote in message ... 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 "Lori" wrote: 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 toolsoptionsview menu. The older version let me put the command on my toolbar. |
#7
|
|||
|
|||
Good point RD.
Gord On Sat, 3 Sep 2005 13:12:58 -0700, "RagDyeR" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
auto hide toolbar in Excel won't work | Excel Discussion (Misc queries) | |||
Toolbar commands | Excel Discussion (Misc queries) | |||
How to copy toolbar settings from Excel 2003? | Excel Discussion (Misc queries) | |||
Excel toolbar | Setting up and Configuration of Excel | |||
Difference in number of Excel NewsGroups | Excel Discussion (Misc queries) |