View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Redskinsfan Redskinsfan is offline
external usenet poster
 
Posts: 9
Default 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