AddToMru if .xls opened by button assigned to macro within it
 

In Excel 2003, I have a workbook containing a macro that is assigned to a
button on the menu bar. The workbook is not open. Clicking the button opens
the workbook & runs the macro. The workbook does not show up on the Recent
Files list, since it was opened automatically. If I were opening it
programatically, I would use Workbooks.Open AddToMru:=True. Is there a way to
add it to the Recent Files list once it's already open?
--
Will

AddToMru if .xls opened by button assigned to macro within it
 

Try

Application.RecentFiles.Add Name:=ThisWorkbook.FullName

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2009
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)

On Wed, 18 Feb 2009 13:42:02 -0800, wpiet
wrote:

In Excel 2003, I have a workbook containing a macro that is assigned to a
button on the menu bar. The workbook is not open. Clicking the button opens
the workbook & runs the macro. The workbook does not show up on the Recent
Files list, since it was opened automatically. If I were opening it
programatically, I would use Workbooks.Open AddToMru:=True. Is there a way to
add it to the Recent Files list once it's already open?

AddToMru if .xls opened by button assigned to macro within it
 

Thanks again, Chip.
--
Will


"Chip Pearson" wrote:

Try

Application.RecentFiles.Add Name:=ThisWorkbook.FullName

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2009
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)

On Wed, 18 Feb 2009 13:42:02 -0800, wpiet
wrote:

In Excel 2003, I have a workbook containing a macro that is assigned to a
button on the menu bar. The workbook is not open. Clicking the button opens
the workbook & runs the macro. The workbook does not show up on the Recent
Files list, since it was opened automatically. If I were opening it
programatically, I would use Workbooks.Open AddToMru:=True. Is there a way to
add it to the Recent Files list once it's already open?