Showing posts with label vba. Show all posts
Showing posts with label vba. Show all posts

Thursday, 22 October 2009

Viewing macro code

You'll need to be able to print the macro code - the actual VBA code. This proves you've actually done the macro and not just drawn a button and pretended to do it!!

This is easy: go ALT + F11

This will open the macro thingy. You may need to click on the individual sheets and/or modules down the left side of the screen to see all the code. You can then copy and paste into a word doc (or screenshot if you need to). You can simply close this window down to go back to your spreadsheet any time you want.