View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.misc
jesmin
 
Posts: n/a
Default How to avoid this Alert screen


Hi Dave:
Let me simplify the problem. Say in workbook1 sheet1 I have a value in
cell ,say,cells(2,5) =2000. Now in workbook2 in sheet1, my
cells(3,5)=workbook1!sheet1!$e$2.
When I am opening workbook2, its opening the alert screen saying that
this workbook2 has links to another workbook. Do you want to update or
Not. I just dont want to show this alert screen. I want to open this
workbook2 simply without any option/alert. I dont have any VB coding in
workbook2. I have my VB in workbook1.
Thanks


--
jesmin
------------------------------------------------------------------------
jesmin's Profile: http://www.excelforum.com/member.php...o&userid=29540
View this thread: http://www.excelforum.com/showthread...hreadid=515142