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.

No comments: