Darren Bartrup
Well-known Member
- Joined
- Mar 13, 2006
- Messages
- 1,296
- Office Version
- 365
- Platform
- Windows
Hi all,
I wasn't sure where to post this, but it's definately not an Excel question but may have a VBA answer.
I'm trying to write up the code used in my Excel spreadsheets - my boss wants an explanation of how it all works just in case I get run over by a bus on the way home and I'd also like to know how it all works when I'm asked to change it six months down the line.
So I'm now in the process of copying my code to Word documents with explanations on what each section of code does. I do include comments in my code, but this is a more encompassing document explaining how each procedure links up, why certain controls need tags, etc.
When I paste the code into the document I format it as Courier New 10pt (HTML Keyboard style), with the rest of the document written in Arial 12pt. When I add line numbering to the code sections (seperated by continuous section breaks) they appear as 12pt type and I can't figure out how to change them to 10pt.
The only way around this I can think of is to number each line by hand, which is just plain silly.
Does anyone know of a way to alter the formatting of automatic line numbers?????
Any help with this would save me alot of time and would be greatly appreciated.
EDIT: I really should look further sometimes. Line numbers are a font style called, surprisingly enough, Line Number. Just modify the font style and mission accomplished.
I wasn't sure where to post this, but it's definately not an Excel question but may have a VBA answer.
I'm trying to write up the code used in my Excel spreadsheets - my boss wants an explanation of how it all works just in case I get run over by a bus on the way home and I'd also like to know how it all works when I'm asked to change it six months down the line.
So I'm now in the process of copying my code to Word documents with explanations on what each section of code does. I do include comments in my code, but this is a more encompassing document explaining how each procedure links up, why certain controls need tags, etc.
When I paste the code into the document I format it as Courier New 10pt (HTML Keyboard style), with the rest of the document written in Arial 12pt. When I add line numbering to the code sections (seperated by continuous section breaks) they appear as 12pt type and I can't figure out how to change them to 10pt.
The only way around this I can think of is to number each line by hand, which is just plain silly.
Does anyone know of a way to alter the formatting of automatic line numbers?????
Any help with this would save me alot of time and would be greatly appreciated.
EDIT: I really should look further sometimes. Line numbers are a font style called, surprisingly enough, Line Number. Just modify the font style and mission accomplished.