View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
JAD JAD is offline
external usenet poster
 
Posts: 43
Default Adding User Dialog to Macro

I have a macro that when activated will add (3) rows to a section of the
worksheet. To enhance flexibility, I would like to interrupt the macro to ask
the end user how many rows they would like to insert, set the macro to the
user number and complete the macro process. The following is the automated
macro that inserts the (3) rows automatically. Any help would be appreciated.
Thank You, JAD


Call Security_Unprotect
Application.Goto Reference:="Me02_END"
ActiveCell.Offset(0, 0).Range("a1:a3").Select
Selection.EntireRow.Insert
ActiveCell.Offset(0, 0).Range("a1").Select
ActiveWorkbook.Names.Add Name:="Me02_NEW_START", RefersToR1C1:=ActiveCell
Application.Goto Reference:="Me_COPY"
Selection.Copy
Application.Goto Reference:="Me02_NEW_START"
ActiveSheet.Paste
Application.Goto Reference:="MM_EQ_Menu_Selection"
Call Security_Protect
End Sub