look at Dialogs in help, you will find both those function catered for, e.g.
application.Dialogs(xlDialogPrint).Show

Signature
HTH
Bob Phillips
(remove nothere from email address if mailing direct)
> Hello, Im doing this spreadsheet model on handling costs and how many
> items of products ive sold from a shop...and I will like to add in some
> macros...can you suggest some macros such as "Save" "Print" etc etc
>
> Thanks
> From John
Neo1 - 07 Mar 2006 19:13 GMT
I've already done those two macros but i was looking for some others
that I could do in such a model stated..
Thanks
From John

Signature
Neo1
Bob Phillips - 07 Mar 2006 20:07 GMT
Well, you will need to articulate your needs and maybe we can help.

Signature
HTH
Bob Phillips
(remove nothere from email address if mailing direct)
> I've already done those two macros but i was looking for some others
> that I could do in such a model stated..
>
> Thanks
> From John