Calling macros in diff worksheet
 

Hello
I have created few macros in worksheet, the same has been saved in
personal.xls file in MSOffice/Office10/xl start folder of C: drive.

My requirement is I wish to call these macros, while working in
new/different worksheets, execute them and the results to be pasted in the
active cell of current working sheet.

Can anybody guide me in this regard

Thanks
--
reply to my posts are welcome

Calling macros in diff worksheet
 

If things are working **to this point - OK** then you should be able to run
your macros in any new book or sheet by pressing the key combination Alt-F8;
your
Macro window (list) should appear. All macros that are in your Personal.xls
workbook you should see prefaced with "Personal.xls!" + the Macro name.
If this is not so, than you are not as far as you need to be.

I further create and add custom icons to my toolbar for several of my macros
in my Personal.xls file

"NSNR" wrote:

Hello
I have created few macros in worksheet, the same has been saved in
personal.xls file in MSOffice/Office10/xl start folder of C: drive.

My requirement is I wish to call these macros, while working in
new/different worksheets, execute them and the results to be pasted in the
active cell of current working sheet.

Can anybody guide me in this regard

Thanks
--
reply to my posts are welcome

Calling macros in diff worksheet
 

As long as it is open, you should be able to use Application.Run. Check it
out in help.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"NSNR" wrote in message
...
Hello
I have created few macros in worksheet, the same has been saved in
personal.xls file in MSOffice/Office10/xl start folder of C: drive.

My requirement is I wish to call these macros, while working in
new/different worksheets, execute them and the results to be pasted in the
active cell of current working sheet.

Can anybody guide me in this regard

Thanks
--
reply to my posts are welcome