II know the very basics for creating a macro. My situation is this: I have
been given a model that my predecessor built that contains macros. Where I am
confused and have a question is that he has one workbook that contains all
the inputs, and at the top of the work book, he has a "click here to generate
report." When you click on it, an entirely new workbook opens up with all
the outputs. How did this happen or should I just buy a book to learn how to
do it?

Confused,
--
hmz
Wash DC

Hi,
if you right click in the buttom you will be able to edit the macro or not
depending if it's password protected, to read about macros go to , in this
web page will explain in detail what I said before

http://www.contextures.com/xlfaqmac.html

if this was helpful please click yes, thanks

"hmz" wrote:

II know the very basics for creating a macro. My situation is this: I have
been given a model that my predecessor built that contains macros. Where I am
confused and have a question is that he has one workbook that contains all
the inputs, and at the top of the work book, he has a "click here to generate
report." When you click on it, an entirely new workbook opens up with all
the outputs. How did this happen or should I just buy a book to learn how to
do it?

Confused,
--
hmz
Wash DC

Hi,

There are many books on the market, you might consider Reed Jacoson's step
by step book and John Walkenback's Power Programming.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"hmz" wrote:

II know the very basics for creating a macro. My situation is this: I have
been given a model that my predecessor built that contains macros. Where I am
confused and have a question is that he has one workbook that contains all
the inputs, and at the top of the work book, he has a "click here to generate
report." When you click on it, an entirely new workbook opens up with all
the outputs. How did this happen or should I just buy a book to learn how to
do it?

Confused,
--
hmz
Wash DC

it does not let me do a right click, but I am looking at the site you
referenced. thank you,
--
hmz
Wash DC


"Eduardo" wrote:

Hi,
if you right click in the buttom you will be able to edit the macro or not
depending if it's password protected, to read about macros go to , in this
web page will explain in detail what I said before

http://www.contextures.com/xlfaqmac.html

if this was helpful please click yes, thanks

"hmz" wrote:

II know the very basics for creating a macro. My situation is this: I have
been given a model that my predecessor built that contains macros. Where I am
confused and have a question is that he has one workbook that contains all
the inputs, and at the top of the work book, he has a "click here to generate
report." When you click on it, an entirely new workbook opens up with all
the outputs. How did this happen or should I just buy a book to learn how to
do it?

Confused,
--
hmz
Wash DC