The Organizer

K

Karen

What happened to the Organizer? It's still in Word, but
I no longer see it in Excel. I want to copy macros and
styles, but now I have to do it the "long way". Thanks.
 
D

Debra Dalgleish

Organizer is in Word, but has never been in Excel.

To copy macros, you can copy a module from one workbook to another, by
dragging and dropping in the Project Explorer window. Or, copy and paste
macro code from one workbook to another.

Or, store your macro code in a workbook that is always open, such as
Personal.xls, and you can use it in any workbook.

To copy Styles from another workbook:
Open the workbook that has the styles you want to copy.
Open the workbook into which you want to copy the styles
Choose Format>Style
Click Merge.
Select the workbook that contains the styles you want to copy.
Click OK
If there are duplicate Style names, you'll be asked if you want to merge
the styles.
 
Top