View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Vivian
 
Posts: n/a
Default Newbie seeks suggestion on recording new macro to print sheets

Hi there, I want to click on a button (created from form), then the print
window appear. I did the following steps:

created a button;
recorded new macro;
File -- Print, the print window appear, but at that time I can't stop
recording. So I clicked OK; a dialog pop up reminds me to save the file.
I saved the file, then the Microsoft Document Imaging appeared.
Then I stoped recording, assigned the macro, clicked the button, it asked to
save as first, and then the Microsoft Document Imaging appeared again.

What a messy, anybody could kindly tell me what's wrong with my work? How
could it be solved using the simplest "recording macro" way.

Thanks for help.

Vivian