Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
List all (complete) codes from a workbook?
Is there any way to completely display all of the macros I have in a
workbook? Not just the names, but the info as well. I'd like to combine several macros together but, I am looking for the shortest way possible to combine the codes. I also want to copy all of my macros (from several workbooks) to store on one (Word) page. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
List all (complete) codes from a workbook?
You can start at
http://www.cpearson.com/excel/vbe.htm -- regards, Tom Ogilvy "J.W. Aldridge" wrote in message oups.com... Is there any way to completely display all of the macros I have in a workbook? Not just the names, but the info as well. I'd like to combine several macros together but, I am looking for the shortest way possible to combine the codes. I also want to copy all of my macros (from several workbooks) to store on one (Word) page. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
List all (complete) codes from a workbook?
To answer your specific question: 1) You can print the entire VBA module.
It will not appear in print as it does on the screen. 2)If you intend to print it, I would recommend copying your code into Word but set up your Word document with font formats first. If you set your Word fonts to Courier 10, it will be close to the code you are copying and will be easier to edit before printing. 3)After you copy the code to word and before you print it, Edit it side by side so you can organize the Word version in a consistent format that you can understand. (i.e. you can tell where one line of code ends and another begins.) 4) You can copy from the code module to Word simply by selecting the code with you browser like any other copy process and then right click on the first page of the Word file you have prepared and click paste. Depending on the amount of code will determine how long it takes to edit it so that you can easily read it in the Word file. "J.W. Aldridge" wrote: Is there any way to completely display all of the macros I have in a workbook? Not just the names, but the info as well. I'd like to combine several macros together but, I am looking for the shortest way possible to combine the codes. I also want to copy all of my macros (from several workbooks) to store on one (Word) page. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
auto-complete from a drop down list and from a different workbook | Excel Worksheet Functions | |||
link words from one list to another and complete the list | Excel Discussion (Misc queries) | |||
auto complete in list | Excel Discussion (Misc queries) | |||
same date and set up on complete workbook | New Users to Excel | |||
Save only Changes....Not complete workbook! | Excel Programming |