How Can I call A Macro From One "Work book" to Another "Work book"?

  • Thread starter Thread starter zameer_india
  • Start date Start date
Z

zameer_india

Hi, All...

I would like to call a macro from one Workbook to another Workbook
What i Mean to say .. for example

Let I have To Workbooks , name workbook1 and Workbook2

In sheet1 of workbook1 i have data like

in the range A1:D4
A B C D
X 2 3 4
Y 3 4 5
Z 4 5 6

I selected specific range mentioned above(A2:D4) and selected th
columns graph

after that i deleted all the data , cut that graph and paste in anothe
"sheet2" , so that what ever the reflections/changes made by me in dat
range from the worksheet1 , occured in Graph of worksheet
successfully.

I recorded a Macro for the entire process.

I got a doubt , Now I want to add another workbook and paste the Grap
as similar process ... Could the Reflections occur same as in th
previous case(same workbook) if i change the data in sheet1 o
workbook1. If NOT then what is the Process to call a macro from On
Workbook to Antoher Workbook? Any help would be appreciated.

Thanx in advance,
Zameer Ahmed syed
 
Back
Top