Printing macros

[pcor]

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]

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

 

[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

 

[Gord Dibben]

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.
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 MS Excel MVP

 

[pcor]

You've beena great help.. Many 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



Gord Dibben MS Excel MVP