Results 1 to 5 of 5

Macro on copied sheet

Threaded View

  1. #1
    Registered User
    Join Date
    10-16-2008
    Location
    DFW
    Posts
    15

    Macro on copied sheet

    Hopefully this will come across right ? I have a macro using the following to bring a shape to the front:

    ActiveSheet.Shapes("Rectangle 447").Select
        Selection.ShapeRange.ZOrder msoBringToFront
    When I make a copy of that sheet the shape becomes a different number for ex. "Rectangle 447" becomes "Rectangle 445" and the macro will not work properly on that copied sheet. Is there any fix for this?

    Thanks in advance,
    Beatnik
    Last edited by beatnik; 10-17-2008 at 06:55 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Macro will not work when sheet is Protected
    By alachape in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-02-2008, 03:13 PM
  2. Strip Macro from copied object ?
    By tekman in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-26-2008, 03:50 PM
  3. create a new sheet macro
    By jsmity in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-08-2008, 12:08 PM
  4. Macro sheet naming and referencing
    By ConorOB1 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-10-2007, 06:13 AM
  5. Replies: 1
    Last Post: 02-19-2007, 04:52 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1