vba courses london - Command Buttons that don;t show when printed | VBA forum

Resolved · Low Priority · Version Standard

Wed 31 Jan 2007, 09:59 Delegate Peter said...

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

Thu 1 Feb 2007, 15:53 Trainer David said...

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

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions
Popular forum topics

VBA tip:

Empty The Clipboard with CutCopyMode

After each Copy/Paste operation in VBA, you should use the following line of code to empty the clipboard. This ensures that the computer memory doesn't overload:

ActiveSheet.Paste
Application.CutCopyMode = False

View all VBA hints and tips