Hi
my excel version is 2016 and I want to clear save as pinned folder list with VBA , I try this code:
Sub ClearRecentFiles()
Dim rf As RecentFile
For Each rf In Application.RecentFiles rf.Delete
Next 'rf
End Sub
but it only clear recent file list and not folder list could you please help me on that (image screenshot) attached
my excel version is 2016 and I want to clear save as pinned folder list with VBA , I try this code:
Sub ClearRecentFiles()
Dim rf As RecentFile
For Each rf In Application.RecentFiles rf.Delete
Next 'rf
End Sub
but it only clear recent file list and not folder list could you please help me on that (image screenshot) attached