Posts by norie

How are you creating the charts?

When you create them do you name them?

Have a look in XL help for the PrintOut method. It applies to various objects including Charts.

The exact code to do what you want depends on the answers to the above questions.

Have you looked at the Shell command?
eg

Dim RetVal
RetVal = Shell("C:\WINDOWS\CALC.EXE", 1)

Quote from Ying&Yang4u

I would like to do it in the form properties, is that possible?

What do you mean by that?

Should it not be

MsgBox ("One of the Distributions is not listed as ''Normal'' or " & _
"''Possion''. Processing will stop.")