| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro assigned to a button | Excel Discussion (Misc queries) | |||
| Macro Assigned to a Button | Excel Discussion (Misc queries) | |||
| How do I know what macro is assigned to a button? | Excel Discussion (Misc queries) | |||
| Tab selecting a button with assigned macro | Excel Programming | |||
| Which Macro Is Assigned to a Button | Excel Programming | |||
Linear Mode
