Posted to microsoft.public.excel.programming

Susanlwh

external usenet poster

Posts: 2

Pause a macro to allow editing

I have designed a macro in Excel 2003 with a yes/no message box. It is
working properly but I need to be able to stop the macro with the yes click
and edit the spreadsheet for any duplicate entries.

I would like to be able to:
Click the yes button
Edit the spreadsheet
Hit enter to resume the macro

Any thoughts would be appreciated!

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
pause a macro	tsmith	Excel Discussion (Misc queries)	9	January 22nd 09 12:47 AM
Pause Macro 2	Ollie	Excel Discussion (Misc queries)	3	June 15th 06 04:49 AM
Pause Macro	cottage6	Excel Programming	2	April 14th 06 04:23 PM
Pause a macro to allow editing of a worksheet	captbluefin[_10_]	Excel Programming	2	December 3rd 03 05:39 PM
Pause macro	Bill Barclift	Excel Programming	0	September 30th 03 09:22 PM

All times are GMT +1. The time now is 12:07 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us