- show developer ribbon
- Record Macro enter some dummy text as name and select personal workbook
- Stop Recording (you did nothing in between, right?)
- Press Visual Basic or ALT-F11
- Select Personal Workbook and Module1, click view code
- replace everything with a sub end sub, e.g. the highlight from a previous post
http://office.microsoft.com/en-us/excel-help/create-and-save-all-your-macros-in-a-single-workbook-HA102174076.aspx
No comments:
Post a Comment