J
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
links to a macro but doesnt appear when you print the worksheet
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
I
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.
associated with macro.
right-click on the button, select Format Control. select Properties
tab. uncheck Print Object option.
that should work.
J
jamie85
Great thanks but how do i associate the button with a macro?
F
Frank Kabel
Hi
right-click on the button and select the option form the context menu.
Frank
right-click on the button and select the option form the context menu.
Frank
J
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?
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?
D
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.
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.