"William Benson" wrote in message
...
I did not get an answer that worked for me in an earlier post, am trying
again - if someone can figure out what is wrong I would really appreciate
it:

I have a subprocedure shown below, in a module which is named CharStats,
in Personal.xls:

Public Sub FindChar()
frmFindCharacters.Show
End Sub

I want the click event of command button on a sheet in another open
workbook to call it, and wrote:

Private Sub CommandButton1_Click()
Application.Run "Personal.xls!FindChar"
End Sub

I am getting an error message saying : "The macro 'Personal.xls!FindChar'
cannot be found.

How bout

FindChar

and shange the sub to just plain sub not private sub

I'm not much of a techo but thats how I call other subroutines