A macro called "changecolors" cannot located.

You said a "module" called "changecolor" exists. But the macro looks for a "macro" (a subroutine) called "changecolor" to execute.

Regards,
Edwin Tam
http://www.vonixx.com


"scottnshelly " wrote:

Last week, i had a workbook that worked perfectly. I went on vacation
and when i came back i get an error "Sub or Fuction not defined". the
only thing that it says is
Private Sub CommandButton3_Click()

Call changecolors

End Sub

what could possibly be wrong with this that was not wrong last week?

and yes, i do have a module with the name changecolors