For this to work, it must be in EACH Excel file that you wish to open! It will not work for "ANY Excel file", but only the ones that contain this macro.
Can you explain what it is that you're trying to accomplish? Is it for multiple users? or just yourself? You could place the file in the XLStart folder (Excel opens all files in this folder when Excel is launched) Paul > >From: C.G.Kumar <kumar.bemlmum...@gmail.com> >To: richard.m...@gmail.com >Cc: excel-macros@googlegroups.com >Sent: Mon, December 20, 2010 12:09:29 AM >Subject: Re: $$Excel-Macros$$ Re: Run a macro every time excel is opened > >I have used the following code; > > >Sub Workbook_Open() >Application.DisplayAlerts = False > On Error Resume Next >Workbooks.Open Filename:= _ > "E:\Documents and Settings\DRIVE\Desktop\Tasks.xls >On Error GoTo 0 > Application.DisplayAlerts = True > > >End Sub > > >I have made macro security to low & i require this macro to run whenever i >open >any excel file. but this is not working.Any suggestion. > > > > >Thanks & Regards, > >C.G.Kumar > >On Sat, Dec 18, 2010 at 6:53 PM, Richard <richard.m...@gmail.com> wrote: > >Create a sub called "sub workbook_open" in "this workbook" and call >>your macro. >> >>On Dec 18, 3:34 am, "C.G.Kumar" <kumar.bemlmum...@gmail.com> wrote: >>> I want a macro to run every time when an excel file is opened. >> >>-- >>---------------------------------------------------------------------------------- >> >>Some important links for excel users: >>1. Follow us on TWITTER for tips tricks and links : >>http://twitter.com/exceldailytip >>2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >>3. Excel tutorials at http://www.excel-macros.blogspot.com >>4. Learn VBA Macros at http://www.quickvba.blogspot.com >>5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >> >>To post to this group, send email to excel-macros@googlegroups.com >> >><><><><><><><><><><><><><><><><><><><><><><> >>Like our page on facebook , Just follow below link >>http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts >> >-- >---------------------------------------------------------------------------------- > >Some important links for excel users: >1. Follow us on TWITTER for tips tricks and links : >http://twitter.com/exceldailytip >2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >3. Excel tutorials at http://www.excel-macros.blogspot.com >4. Learn VBA Macros at http://www.quickvba.blogspot.com >5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > >To post to this group, send email to excel-macros@googlegroups.com > ><><><><><><><><><><><><><><><><><><><><><><> >Like our page on facebook , Just follow below link >http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts > -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
