Just a thought, check if the object is locked (from object
properties). I believe objects generally shifts up / down when you
delete rows. Might be something happening between migration from / to
2003 and 2007 version.
This is interesting and there are learners who wish to know the main
cause of this :)
Best Regards,
DILIPandey
On 6/23/11, 0 1 <hhholme...@gmail.com> wrote:
> 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
>
--
Thanks & Regards,
DILIP KUMAR PANDEY, mvp
MBA,B.Com(Hons),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 62, India
--
----------------------------------------------------------------------------------
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
