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
