| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Running macro x # of times with a prompt
I have this macro and i want to have a prompt come up and ask how many times
the user wants to run it.. Thanks in advance Sub New_Contractor() ' ' New_Contractor Macro ' Macro recorded 8/3/2006 by Parsons User ' ' ActiveSheet.Protect UserInterfaceOnly:=True Rows("20:50").Select Selection.Copy Rows("51:51").Select Selection.Insert Shift:=xlDown Application.CutCopyMode = False Range("D52:I52").Select ActiveWindow.SmallScroll Down:=8 End Sub |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| error running a paste macro | Excel Worksheet Functions | |||
| Problems in running a macro in another workbook | Excel Discussion (Misc queries) | |||
| Macro to Prompt for File -- Neophite Needs HELP | Excel Discussion (Misc queries) | |||
| Running a Macro automatically from Excel | Excel Worksheet Functions | |||
| Macro running problem | Excel Discussion (Misc queries) | |||
Threaded Mode
