Dear friends,
I have created the following code to to trap
"windowactivate" event and execute the code from personal macro
workbook when the activate sheet name is "sap vs phy".But it works
only when the excel is opened for first time.Kindly check the code &
give necessary correction so that once maco is executed & whenever
excel window is activated& w.shhet name is "sap vs phy" then the
following code is executed
--
----------------------------------------------------------------------------------
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/discussexcel
