How to print macros

cdrewett · May 21st, 2002, 02:39 PM

Can someone tell me how to print the macro on a page - my daughter needs to do this for her IT coursework and the page keeps printing without the macro showing....any tips out there?

Jack in the UK · May 21st, 2002, 02:43 PM

export the file from VBE as a *bas file and save location on desktop..

then open the saved bas file in word or notpad and print it, might go wonky as no formatting but its as VBE would allow and except workable bas importation so the print will be RAW, thisis correct.

IT tutor might not like

suggest tidy, do not import a tidy bas file thou: wont like it

NateO · May 21st, 2002, 02:45 PM

When you go into the module of choice in the Visual Basic Editor select File (menu)->Print. Choose 'Current Module' for the range & make sure the 'Code' check box is checked.

If all else fails:

Go into the module, hit ctrl-a (select all), hit ctrl-c (copy), go to Word or a Word Editor (you can actually insert a Word Object in an Excel worksheet if you like) and hit ctrl-v (paste). It would be nice to make sure your visual basic editor is printing properly though.

_________________
Cheers, NateO

[ This Message was edited by: NateO on 2002-05-21 13:51 ]

May 21st, 2002, 02:43 PM	#2
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,065	export the file from VBE as a *bas file and save location on desktop.. then open the saved bas file in word or notpad and print it, might go wonky as no formatting but its as VBE would allow and except workable bas importation so the print will be RAW, thisis correct. IT tutor might not like suggest tidy, do not import a tidy bas file thou: wont like it __________________ Free Excel based Web Toolbar available here. Jack in the UK J & R Excel Solutions "making Excel work for you"

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 21st, 2002, 02:39 PM	#1
cdrewett New Member Join Date: May 2002 Location: Croydon, UK Posts: 2	Can someone tell me how to print the macro on a page - my daughter needs to do this for her IT coursework and the page keeps printing without the macro showing....any tips out there?

May 21st, 2002, 02:45 PM	#3
NateO Legend Join Date: Feb 2002 Location: Minneapolis, Mn, USA Posts: 9,704	When you go into the module of choice in the Visual Basic Editor select File (menu)->Print. Choose 'Current Module' for the range & make sure the 'Code' check box is checked. If all else fails: Go into the module, hit ctrl-a (select all), hit ctrl-c (copy), go to Word or a Word Editor (you can actually insert a Word Object in an Excel worksheet if you like) and hit ctrl-v (paste). It would be nice to make sure your visual basic editor is printing properly though. _________________ Cheers, NateO [ This Message was edited by: NateO on 2002-05-21 13:51 ]