Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
msg boxes
i have a macro that i recorded and when i run it, it pops
up msg boxes to confirm what i want to do....is there a way to make these msg box selections behind the scenes in the macro thanks doug |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
msg boxes
Do you mean put the answers in the code? Surely that would mean that you
know in advance what will be chosen, so just take that logic route. -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "doug" wrote in message ... i have a macro that i recorded and when i run it, it pops up msg boxes to confirm what i want to do....is there a way to make these msg box selections behind the scenes in the macro thanks doug |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
msg boxes
Sub Macro1()
* * Recorded by doug * Application.DisplayAlerts = False ' current code Application.DisplayAlerts = True End Sub might be what you are after. -- Regards, Tom Ogilvy "doug" wrote in message ... i have a macro that i recorded and when i run it, it pops up msg boxes to confirm what i want to do....is there a way to make these msg box selections behind the scenes in the macro thanks doug |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data validation boxes, outputting a final number from the boxes | Excel Discussion (Misc queries) | |||
Moving. Want to number boxes and inventory contents of boxes | Charts and Charting in Excel | |||
Selecting subsets using combo boxes or list boxes | Excel Discussion (Misc queries) | |||
Questions on combo boxes and list boxes. | New Users to Excel | |||
How do i create a value for check boxes or option boxes | Excel Discussion (Misc queries) |