C
cbecher
I was trying to set up a macro using the Org Chart wizard and go through the
process but when it asks to save the macro to a worksheet, I can't figure out
how to save it to the entire workbook. I can only save it to a specific sheet
that is created already. The problem with that is everytime the wizard runs,
a new sheet is populated and therefore the macro won't run. Is there a way to
automate the Org chart wizard if I know what I want it to do and where to get
the information from? I am not accustomed to using Visio and can't seem to
find how to make a universal macro. Some help would be appreciated.
process but when it asks to save the macro to a worksheet, I can't figure out
how to save it to the entire workbook. I can only save it to a specific sheet
that is created already. The problem with that is everytime the wizard runs,
a new sheet is populated and therefore the macro won't run. Is there a way to
automate the Org chart wizard if I know what I want it to do and where to get
the information from? I am not accustomed to using Visio and can't seem to
find how to make a universal macro. Some help would be appreciated.