Peter has attended:
Excel VBA Intro Intermediate course
Command Buttons that don;t show when printed
Hi,
I am writing a report and usually use buttins from the forms menu as these do not show up on print outs, but I need to activate a user form form a button so I need to use a command button from the control toolbox menu, but these show up on printouts and I would like it not to be printed. I cna't find anything in the properties of the command button that looks like it may help so any suggestiond would be more than welcome.
Thanks
Peter
RE: Command Buttons that don;t show when printed
Hi Peter
Thanks you for your question.
Have you tried the customised macro button, available from the cutomise dialog box, from Tools menu. The commands tab lets you select under Macros, a custom button that you can assign to a macro and put on a new toolbar if necessary.
Try that see if it helps
Feel free to recommend the forum to family, friends or work collegues.
Regards
BEST Training
