Our company is new to Excel 2007. I have moderate experience in VBA. When we converted to Excel 2007 from Excel 2000 we have a staff member who suddenly found that 1000+ of her excel files for whatever reason has a shadow effect on misc shapes in the excel files. Each of the files has between 1 and 30 worksheets, each with the problem.
I was going to create a macro which removed this effect, but I noticed that the vba capture (record macro) does not seem to record anything I do with shapes. As I am not a VBA proggrammer by nature I usually start by recording and then hacking my way through. Here is the manual procedure that works in excel: 1. highlight the shape(s) 2. right click and choose "format shape" 3. choose shadow, and change color from black to white (although they are not sure why it's set ON and black in the first place) I cannot figure out yet how to get this into vba to try to automate this. Can someone send me the code to do this? Our office online help doesn't seem to have much in it.. not sure if we did not configure it correctly on our end when we installed office in our shared network environment. I also tried a handful of google searches but never have found the exact match of what I'm trying to do in the simple 3 step proccess above. -- ---------------------------------------------------------------------------------- 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
