ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   delete from pull down list (https://www.excelbanter.com/excel-discussion-misc-queries/125338-delete-pull-down-list.html)

smstigall

delete from pull down list
 
Have deleted old files. Need to delete file names from drop down list.

Bob Phillips

delete from pull down list
 
Depends how the list is sourced. If it is a range on a worksheet, just
delete from that list.

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"smstigall" wrote in message
...
Have deleted old files. Need to delete file names from drop down list.




Gord Dibben

delete from pull down list
 
ToolsOptionsGeneral

Uncheck "recently used files list" or set to 0.

The File List will be gone.

Re-check and set a number.


Gord Dibben MS Excel MVP

On Tue, 9 Jan 2007 08:20:01 -0800, smstigall
wrote:

Have deleted old files. Need to delete file names from drop down list.



Bob Phillips

delete from pull down list
 
Never read it that way <G

"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
ToolsOptionsGeneral

Uncheck "recently used files list" or set to 0.

The File List will be gone.

Re-check and set a number.


Gord Dibben MS Excel MVP

On Tue, 9 Jan 2007 08:20:01 -0800, smstigall
wrote:

Have deleted old files. Need to delete file names from drop down list.





Gord Dibben

delete from pull down list
 
Hopefully, one of us will have guessed correctly<g




On Tue, 9 Jan 2007 18:30:28 -0000, "Bob Phillips" wrote:

Never read it that way <G

"Gord Dibben" <gorddibbATshawDOTca wrote in message
.. .
ToolsOptionsGeneral

Uncheck "recently used files list" or set to 0.

The File List will be gone.

Re-check and set a number.


Gord Dibben MS Excel MVP

On Tue, 9 Jan 2007 08:20:01 -0800, smstigall
wrote:

Have deleted old files. Need to delete file names from drop down list.






All times are GMT +1. The time now is 10:00 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com