+ Reply to Thread
Results 1 to 2 of 2

Macro working on one sheet but not another

  1. #1
    Forum Contributor
    Join Date
    05-11-2006
    Posts
    104

    Macro working on one sheet but not another

    Hi,

    I have created the attached spreadsheet as a reading record for my class at school. The form was originally created on the tab called Spring 2. All 3 of the macro buttons work fine on this sheet, and I have copied the sheet to another 5 worksheets so that I can record results for all the school year.

    The macros are run by pressing one of three buttons, First Name, Last Name or Priority. These are linked on every sheet back to the original macro by a call code.

    However, on some sheets when you try to use the Priority button it halts and says that some merges cells are not idenical. This also occasionally happens on other sheets with different buttons.

    I can't work out the problem is seeing as though all six of the sheets should be - and are identical as far as I can see.

    Any advice gratefully received

    Carl
    Attached Files Attached Files

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,474
    Hi,
    When I click the Priority button it comes up with an error because the sheet is protected, you need to unprotect the sheet for the sort macro to work

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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