 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / October 2006Printing 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 Open a module in your Personal.xls by double-clicking. Edit>Select all. File>Print>Selection 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 >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 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 > Open a module in your Personal.xls by double-clicking. > [quoted text clipped - 17 lines] > >Thanks > >pcor 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 >Worked real fine...thanks >Now can I tag you for an other help. [quoted text clipped - 24 lines] >> >Thanks >> >pcor Gord Dibben MS Excel MVP You've beena great help.. Many thanks PCOR > Toolbar customizations are saved in your Excel11.xlb file. > [quoted text clipped - 52 lines] > > Gord Dibben MS Excel MVP |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.