Word and line numbering - SOLVED

Darren Bartrup

Well-known Member
Joined
Mar 13, 2006
Messages
1,296
Office Version
  1. 365
Platform
  1. 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.
 

Excel Facts

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,168,117
Messages
5,857,477
Members
431,882
Latest member
saaaaaaaaaaaaaaaaaaaaaa

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top