I had this macro in a workbook attached to a button on sheet1.
Sub months()
   'count the number of worksheets
   Sheets(1).Select
   n = Worksheets.Count + 1
   i = 2
   ' Skip the first worksheet - it's the controls sheet
   Text = Range("D3")
   Do
       Sheets(i).Select

       Range("V6").Select
       ActiveCell.FormulaR1C1 = Text
       i = i + 1
   Loop Until i = n
End Sub

It goes to the 2nd sheet and changes a date.  This macro worked fine
until I added a userform now this macro button doesn't work.  It now
says the variables are undefined.  Well they are undefined but they
worked before.  I just want to know the reason why?  The macro is in
module 1.    The command button code is simple.
Public Sub CommandButton1_Click()
months
End Sub

So this sheet object with the button on can't find the module because
it doesn't know to look in both the module and the userform?   The
userform macro is called from sheet1 as well.  Just trying to
understand the process
tnx,

Is the reason because of adding the userform now this button doesn't
know how to find the months macro in the module?  It could find it
before.  NOthing is really changed except for adding a userform.
tnx,