Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Hide Drop Down Arrows in Table Headers
I'm using Excel 2007. I select a range and define it as a table. Excel puts
drop down arrows on the column headers. Is there any way to hide the drop downs, and still keep the range as a table? Steve |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Hide Drop Down Arrows in Table Headers
Hi Steve
As far as I am aware, there is no setting for this. The following code will switch the arrows off. Similar code with the attribute set to True will switch them back on Sub HideArrows() Dim c As Range Dim i As Integer i = Cells(1, 1).End(xlToRight).Column Application.ScreenUpdating = False For Each c In Range(Cells(1, 1), Cells(1, i)) c.AutoFilter Field:=c.Column, visibledropdown:= False Next Application.ScreenUpdating = True End Sub -- Regards Roger Govier "Steve Haack" wrote in message ... I'm using Excel 2007. I select a range and define it as a table. Excel puts drop down arrows on the column headers. Is there any way to hide the drop downs, and still keep the range as a table? Steve |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Hide Drop Down Arrows in Table Headers
In 2003 I would go to ToolsOptionsViewObjectsHide All
Gord Dibben MS Excel MVP On Mon, 8 Sep 2008 07:31:01 -0700, Steve Haack wrote: I'm using Excel 2007. I select a range and define it as a table. Excel puts drop down arrows on the column headers. Is there any way to hide the drop downs, and still keep the range as a table? Steve |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Hide Drop Down Arrows in Table Headers
Hi Gord
Unfortunately in XL2007 Round Office buttonExcel optionsAdvanced Display options for this WorkbookFor Objects show Nothing (Hide Objects) does not prevent the filter buttons on Tables from being hidden. -- Regards Roger Govier "Gord Dibben" <gorddibbATshawDOTca wrote in message ... In 2003 I would go to ToolsOptionsViewObjectsHide All Gord Dibben MS Excel MVP On Mon, 8 Sep 2008 07:31:01 -0700, Steve Haack wrote: I'm using Excel 2007. I select a range and define it as a table. Excel puts drop down arrows on the column headers. Is there any way to hide the drop downs, and still keep the range as a table? Steve |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Hide Drop Down Arrows in Table Headers
Thanks Roger.
Gord On Mon, 8 Sep 2008 20:48:56 +0100, "Roger Govier" <roger@technology4unospamdotcodotuk wrote: Hi Gord Unfortunately in XL2007 Round Office buttonExcel optionsAdvanced Display options for this WorkbookFor Objects show Nothing (Hide Objects) does not prevent the filter buttons on Tables from being hidden. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do you get the drop down arrows within cells on excel? | Excel Discussion (Misc queries) | |||
how to hide "All" in drop-down menu of my pivot table | Excel Discussion (Misc queries) | |||
Filter arrows on drop down lists | Excel Discussion (Misc queries) | |||
DROP DOWN ARROWS | Excel Discussion (Misc queries) | |||
Getting rid of drop down arrows | New Users to Excel |