Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to record a Macro in an intermediate state?
Generally I know how to record a Macro, but this is a special case,
because I just want to record a Macro to call a pop-up windows for example, what I want is following: If one right-click on the "table1" on the left corner of Excel, and select the menu "Move/copy ...", a pop-up windows will open, if this pop-up windows is not closed, it is not possible to click on the Excel, but what I want is just to record a Macro to call that pop-up windows, how? Thank you if some one can give me some suggestions. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to record a Macro in an intermediate state?
That's a built-in dialog. Macro recorder won't record that you used it, just
it's results. Application.Dialogs(xlDialogWorkbookCopy).Show or Application.Dialogs(xlDialogWorkbookMove).Show Will show the dialog. I have no idea how to fill it though. HTH, wrote in message ups.com... Generally I know how to record a Macro, but this is a special case, because I just want to record a Macro to call a pop-up windows for example, what I want is following: If one right-click on the "table1" on the left corner of Excel, and select the menu "Move/copy ...", a pop-up windows will open, if this pop-up windows is not closed, it is not possible to click on the Excel, but what I want is just to record a Macro to call that pop-up windows, how? Thank you if some one can give me some suggestions. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
replace state names with state code abbreviations | Excel Worksheet Functions | |||
How can I show state-by-state data (as silos) on a map of NA | Charts and Charting in Excel | |||
Tri state macro | Excel Programming | |||
Converting State Names to State Abbreviations | Excel Discussion (Misc queries) | |||
Record Macro - Record custom user actions | Excel Programming |