| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Printing macros
I have number of macros in my files PERSONAL.XLS. Is there an easy way to
print them out to file or paper Thanks pcor |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Printing macros
Open a module in your Personal.xls by double-clicking.
EditSelect all. FilePrintSelection You can print to hard-copy or to a *.prn file through your Print Setup. Or a third-party application. Pretty-Print: http://www.submain.com/?nav=products.pcp has a free evaluation copy. Gord Dibben MS Excel MVP On Thu, 19 Oct 2006 13:57:01 -0700, pcor wrote: I have number of macros in my files PERSONAL.XLS. Is there an easy way to print them out to file or paper Thanks pcor |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Printing macros
Worked real fine...thanks
Now can I tag you for an other help. I am using Office 2003 (excel) I have made myself a nice tool bar to activate all thsee macro. How can I save this tool bar to use on an other computer. I am using Excel 2003 Thanks "Gord Dibben" wrote: Open a module in your Personal.xls by double-clicking. EditSelect all. FilePrintSelection You can print to hard-copy or to a *.prn file through your Print Setup. Or a third-party application. Pretty-Print: http://www.submain.com/?nav=products.pcp has a free evaluation copy. Gord Dibben MS Excel MVP On Thu, 19 Oct 2006 13:57:01 -0700, pcor wrote: I have number of macros in my files PERSONAL.XLS. Is there an easy way to print them out to file or paper Thanks pcor |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Printing macros
Toolbar customizations are saved in your Excel11.xlb file.
If the other computer is just for your own use, you can export that file. Find the Excel11.xlb file on the second computer and re-name it. Copy the Excel11.xlb file from first computer. You would be better off if you created the Toolbar "on the fly" when your Personal.xls opens. The Toolbar can be built "on the fly" so you don't overwrite anybody's *.xlb file. See Debra Dalgleish's site for tips on creating Toolbars from code. http://www.contextures.on.ca/xlToolbar02.html For menus, here is Dave Peterson's advice.................. For additions to the worksheet menu bar, I really like the way John Walkenbach does it in his menumaker workbook: http://j-walk.com/ss/excel/tips/tip53.htm Gord Dibben MS Excel MVP On Thu, 19 Oct 2006 17:52:01 -0700, pcor wrote: Worked real fine...thanks Now can I tag you for an other help. I am using Office 2003 (excel) I have made myself a nice tool bar to activate all thsee macro. How can I save this tool bar to use on an other computer. I am using Excel 2003 Thanks "Gord Dibben" wrote: Open a module in your Personal.xls by double-clicking. EditSelect all. FilePrintSelection You can print to hard-copy or to a *.prn file through your Print Setup. Or a third-party application. Pretty-Print: http://www.submain.com/?nav=products.pcp has a free evaluation copy. Gord Dibben MS Excel MVP On Thu, 19 Oct 2006 13:57:01 -0700, pcor wrote: I have number of macros in my files PERSONAL.XLS. Is there an easy way to print them out to file or paper Thanks pcor Gord Dibben MS Excel MVP |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Printing macros
You've beena great help.. Many thanks
PCOR "Gord Dibben" wrote: Toolbar customizations are saved in your Excel11.xlb file. If the other computer is just for your own use, you can export that file. Find the Excel11.xlb file on the second computer and re-name it. Copy the Excel11.xlb file from first computer. You would be better off if you created the Toolbar "on the fly" when your Personal.xls opens. The Toolbar can be built "on the fly" so you don't overwrite anybody's *.xlb file. See Debra Dalgleish's site for tips on creating Toolbars from code. http://www.contextures.on.ca/xlToolbar02.html For menus, here is Dave Peterson's advice.................. For additions to the worksheet menu bar, I really like the way John Walkenbach does it in his menumaker workbook: http://j-walk.com/ss/excel/tips/tip53.htm Gord Dibben MS Excel MVP On Thu, 19 Oct 2006 17:52:01 -0700, pcor wrote: Worked real fine...thanks Now can I tag you for an other help. I am using Office 2003 (excel) I have made myself a nice tool bar to activate all thsee macro. How can I save this tool bar to use on an other computer. I am using Excel 2003 Thanks "Gord Dibben" wrote: Open a module in your Personal.xls by double-clicking. EditSelect all. FilePrintSelection You can print to hard-copy or to a *.prn file through your Print Setup. Or a third-party application. Pretty-Print: http://www.submain.com/?nav=products.pcp has a free evaluation copy. Gord Dibben MS Excel MVP On Thu, 19 Oct 2006 13:57:01 -0700, pcor wrote: I have number of macros in my files PERSONAL.XLS. Is there an easy way to print them out to file or paper Thanks pcor Gord Dibben MS Excel MVP |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hide Macro's in Toolbar / Macro's list | Excel Discussion (Misc queries) | |||
| how do I run excel 4.0 macros on excel 2000 | Excel Discussion (Misc queries) | |||
| Printing subset of pages dynamically using excel macros | Excel Discussion (Misc queries) | |||
| Macros Move when Printing | Excel Discussion (Misc queries) | |||
| Enabling macros | Excel Discussion (Misc queries) | |||
Linear Mode
