Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Spreadsheet print including macro buttons?
I am trying to print an Excel spreadsheet which includes macro buttons, but
the button does not appear in print. Can anyone please help? |
#2
|
|||
|
|||
Hi
if you created the button from the Forms toolbar then it won't - if you create the button from either the control toolbox or a drawing object (both which can be linked to macros) then they will cheers JulieD "gunga" wrote in message ... I am trying to print an Excel spreadsheet which includes macro buttons, but the button does not appear in print. Can anyone please help? |
#3
|
|||
|
|||
And if, like me, you don't lilke the control toolbox, just use a shape
instead. In properties you can choose to print/not -- Don Guillett SalesAid Software "JulieD" wrote in message ... Hi if you created the button from the Forms toolbar then it won't - if you create the button from either the control toolbox or a drawing object (both which can be linked to macros) then they will cheers JulieD "gunga" wrote in message ... I am trying to print an Excel spreadsheet which includes macro buttons, but the button does not appear in print. Can anyone please help? |
#4
|
|||
|
|||
Julie,
Actually, the command button from the Forms toolbar will print if you Right-click, select Format Control and checkmark "Print object " on the Properties tab. Regards, Jim Cone San Francisco, USA "JulieD" wrote in message ... Hi if you created the button from the Forms toolbar then it won't - if you create the button from either the control toolbox or a drawing object (both which can be linked to macros) then they will cheers JulieD "gunga" wrote in message ... I am trying to print an Excel spreadsheet which includes macro buttons, but the button does not appear in print. Can anyone please help? |
#5
|
|||
|
|||
Julie
A button from the Forms Toolbar should print. Right-click on it and Format ControlPropertiesCheckmark "Print Object". gunga should check this property on the buttons in question on the sheet. Gord Dibben Excel MVP On Thu, 10 Feb 2005 23:54:18 +0800, "JulieD" wrote: Hi if you created the button from the Forms toolbar then it won't - if you create the button from either the control toolbox or a drawing object (both which can be linked to macros) then they will cheers JulieD "gunga" wrote in message ... I am trying to print an Excel spreadsheet which includes macro buttons, but the button does not appear in print. Can anyone please help? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is there a way to insert a formula, password or macro in an excel spreadsheet that will automatically delete the spreadsheet? | Excel Discussion (Misc queries) | |||
Excel spreadsheet won't print..but everything else does | Excel Discussion (Misc queries) | |||
Spreadsheet "buttons" that cannot be removed | Excel Discussion (Misc queries) | |||
Setting up a macro to print? | Excel Worksheet Functions | |||
How do i print out my spreadsheet with macro buttons? | Excel Discussion (Misc queries) |