A macro used to delete empty rows and assign some values on multiple
worksheets is, for some reason, also deleting all drawing objects (e.g.,
textboxes, lines, etc.) in the workbook. The problem only occurs on one PC
(the user just got 2007 installed). (When she was using 2003 the macro
worked fine.) I tested the macro on other PCs with 2007 and it works fine.
So I suspect this user has some particular setting in her new Excel install
that's contributing to the problem. Any suggestions where to look?
The objects are on the sheet before she runs the code, but after she runs it
the objects are gone. The worksheet and macro were created in 2003, and she
(just like all other users) is opening it in compatibility mode. But the
problem happens for her whether she uses the .xls version or the .xlsm
version.
Because it works fine on all other PCs, I doubt it's the macro, but just in
case the macro simply:
1. Activates the first sheet
2. Deletes rows that meeting a certain criteria (EntireRow.Delete)
3. Assigns some values to some named ranges (Range("MyCell").Value =
intSomeVariable defined earlier
Any idea what setting on her computer / Excel installation might cause this
behavior?
--
----------------------------------------------------------------------------------
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
