Do VBA Projects remaining visible in VBAProject window after they are closed matter somehow?

		Microsoft Office Forums > Microsoft Excel > Excel Programming
Do VBA Projects remaining visible in VBAProject window after they are closed matter somehow?

FAQ

Thread Tools

Display Modes

10-15-2023, 10:30 PM

ArviLaanemets ArviLaanemets is offline

Do VBA Projects remaining visible in VBAProject window after they are closed matter somehow?

Windows 8

Office 2016

Expert

Join Date: May 2017

Posts: 960

Quote:

Originally Posted by p45cal

Check out Application.RecentFiles.
The single line:
Application.RecentFiles(1).Delete
removes the most recently added recent file entry.
Perhaps you could add this line within each iteration of your loop?

It worked. Thanks!

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Word 2013, when switching to next window, often opens it as a tiny window	amz	Word	1	04-20-2021 12:25 AM
How to call a function in VBAProject(PERSONAL.XLSB)	coffent	Excel Programming	0	05-17-2020 11:31 AM
How to show days remaining	oliboi	Excel	6	01-24-2019 10:29 AM
Word window empty when opened minimized while Visible is False	qtutorm	Word VBA	2	10-08-2018 09:10 AM
Time Remaining Progress Bar	teza2k06	Excel	1	05-13-2014 05:41 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:44 PM.