![]() |
Can VBA be used to clear the recently used file list?
Is is possible using VBA in Excel to clear ALL items in the recently used
file list? I'm talking about the recently used files when you click "Start" then "Documents". If this is possible, could someone please post the code to do this? Thanks. |
Can VBA be used to clear the recently used file list?
HiQuartz,
If you want to hide the Excel recent file list display, try: Sub Tester() Application.DisplayRecentFiles = False End Sub If you want to clear and re-initialise the list, try: Sub Tester02() With Application .DisplayRecentFiles = False .DisplayRecentFiles = True .RecentFiles.Maximum = 3 '<<==== CHANGE TO SUIT End With End Sub Note that neither of the subs erases the windows recent file list, only Excel's ability to report the list. --- Regards, Norman "quartz" wrote in message ... Is is possible using VBA in Excel to clear ALL items in the recently used file list? I'm talking about the recently used files when you click "Start" then "Documents". If this is possible, could someone please post the code to do this? Thanks. |
Can VBA be used to clear the recently used file list?
Hi quartz,
You can use: Kill CreateObject("WScript.Shell").SpecialFolders("Rece nt") & "\*.*" Regards, MP "quartz" a écrit dans le message de ... Is is possible using VBA in Excel to clear ALL items in the recently used file list? I'm talking about the recently used files when you click "Start" then "Documents". If this is possible, could someone please post the code to do this? Thanks. |
Can VBA be used to clear the recently used file list?
Thanks so much!!!
"Michel Pierron" wrote: Hi quartz, You can use: Kill CreateObject("WScript.Shell").SpecialFolders("Rece nt") & "\*.*" Regards, MP "quartz" a écrit dans le message de ... Is is possible using VBA in Excel to clear ALL items in the recently used file list? I'm talking about the recently used files when you click "Start" then "Documents". If this is possible, could someone please post the code to do this? Thanks. |
All times are GMT +1. The time now is 10:58 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com