vba courses london - command buttons dont show
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft VBA Training and help » vba courses london - Command Buttons that don;t show when printed

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

resolvedResolved · Low Priority · Version Standard

replyReply Wed 31 Jan 2007, 09:59Delegate 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

For upcoming training course dates see: Pricing & availability

replyReply Thu 1 Feb 2007, 15:53Trainer 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

 

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


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard