98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft VBA Training and help » vba courses london - Command Buttons that don;t show when printed | VBA forum
vba courses london - Command Buttons that don;t show when printed | VBA forum
Resolved · Low Priority · Version Standard
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
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
Training information:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
VBA tip:Empty The Clipboard with CutCopyModeAfter 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: |
