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

The UK's most regular instructor-led training courses.
Training information: vba courses london · Excel london

Resolved · Low Priority · Version Standard

Command Buttons that don;t show when printed

Peter has attended:
Excel VBA course

by - delegate Peter [2 posts] (2007 Jan 31 Wed, 09:59) Reply

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

by - trainer David gold contributer [416 posts] (2007 Feb 1 Thu, 15:53) Reply

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

· What Is Microsoft Excel VBA and How Can It Help You Work Smarter?
· Introduction to Visual Basic for Applications
· Visual Basic Returns To The Macintosh
· Should You Send Managers To VBA Training?
· Company Roles in Visual Basic Training

Vba tip:

Add A New Sheet at the end of the Workbook

To add a new sheet at the end of the workbook you need to count the sheets in the workbook using:

Sheets.Count

Then use this value as the rank of the sheet after which you want to add the new sheet:

Sheets.Add After:=Sheets(Sheets.Count)

View all VBA hints and tips