debugging error "cannot jump to 'sheets' because it is hidden" help please!!

Hi and welcome to the forum.

When creating VBA code you should avoid instructions like .Activate & .Select. These are rarely necessary. You can generally work with objects / ranges etc by addressing them directly with your code. The macro recorder is great for learning and capturing the basic instructions but it will almost always need editing to tidy it up and for the removal of stuff that isn't necessary.

Remove the

Formula:

Please Login or Register  to view this content.

line since if the Performance sheet is hidden then obviously you can't physically see it and hence select it. If you want to unhide the sheet then use

Please Login or Register  to view this content.

And here's another tip. Avoid using sheet tab names in VBA code. Users can too easily change them and if they're hard coded a macro will fail. Always use the Sheet VB Codename - that's the first item shown for each sheet in the Project Explorer list of sheets. i.e assuming the Perfomance sheet is Sheet1 use

Please Login or Register  to view this content.

Just in case Richards post doesn't solve your issue -

This part of the code works OK for me. (other than that you seem to refer to a named range you are selecting then you sort by a specific set range B5:AI20, maybe those are supposed to refer to the same thing?)

Do you have a form or something with some sort of object called "sheets" on it?