ExcelBanter - hide drop down list

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - hide drop down list (https://www.excelbanter.com/excel-discussion-misc-queries/196594-hide-drop-down-list.html)

Julie

hide drop down list

When I do a query with excel to our data base, the data comes back as a table
with drop down boxes. How do I hide those drop down boxes? I don't believe
"convert to range" is the right choice because I want to be able to refresh
the query in the future.
--
Julie

Debra Dalgleish

hide drop down list

Choose DataFilterAutoFilter to turn off the filter.

Julie wrote:
When I do a query with excel to our data base, the data comes back as a table
with drop down boxes. How do I hide those drop down boxes? I don't believe
"convert to range" is the right choice because I want to be able to refresh
the query in the future.

--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.html
Blog: http://blog.contextures.com

All times are GMT +1. The time now is 05:58 AM.