comand button

[jamie85]

Is there a way to create a button that appears on the worksheet an
links to a macro but doesnt appear when you print the worksheet

 

[icestationzbra]

you can use Forms toolbar to create a command button. this button can be
associated with macro.

right-click on the button, select Format Control. select Properties
tab. uncheck Print Object option.

that should work.

 

[jamie85]

Great thanks but how do i associate the button with a macro?

 

[Frank Kabel]

Hi
right-click on the button and select the option form the context menu.

Frank

 

[jamie85]

great thanks for that guys

Another question. After i have entered information into the spreadsheet
and printed out the statement, i would like that statement to be stored
in a seperate worksheet and the information i entered to be deleted.
How can this be done?

 

[Dave Peterson]

Are you keeping the whole worksheet?

If yes, then make a "template" worksheet. And each time you need to create a
new worksheet, copy this one. (Select|Edit|Move or copy sheet.)

Then you'll always have your template sheet and you'll have the completed
version, too.

ps. Keep a copy of the template sheet--someone will write over it and you'll
have to clear it or recreate it.