|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
September 8th 08, 03:31 PM
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 
|
| Ads |
|
#2
September 8th 08, 05:40 PM
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
September 8th 08, 06:20 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Hide Drop Down Arrows in Table Headers
In 2003 I would go to Tools>Options>View>Objects>Hide 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
September 8th 08, 08:48 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Hide Drop Down Arrows in Table Headers
Hi Gord
Unfortunately in XL2007 Round Office button>Excel options>Advanced Display options for this Workbook>For 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 Tools>Options>View>Objects>Hide 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
September 9th 08, 06:08 PM
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 button>Excel options>Advanced >Display options for this Workbook>For Objects show >Nothing (Hide Objects) >does not prevent the filter buttons on Tables from being hidden.
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| How do you get the drop down arrows within cells on excel? | Alex - Crown | Excel Discussion (Misc queries) | 1 | April 16th 07 11:16 AM |
| how to hide "All" in drop-down menu of my pivot table | nader | Excel Discussion (Misc queries) | 0 | January 26th 07 12:17 AM |
| Filter arrows on drop down lists | HRman | Excel Discussion (Misc queries) | 0 | April 5th 06 10:01 AM |
| DROP DOWN ARROWS | Dale M | Excel Discussion (Misc queries) | 0 | March 21st 06 03:24 PM |
| Getting rid of drop down arrows | jayceejay | New Users to Excel | 3 | December 8th 04 09:01 PM |
Linear Mode
