I have an Excel workbook with approximately 50 worksheets; I have been able
to enter into the VBA the following a) automatically name worksheets, b) sort
worksheets by name,and c) utilizing uppercase characters in specified areas.

My problem is with the first worksheet, which is a master inventory sheet, I
created a macro and appropriately used the shortcut "Ctrl A"; the Macro works
perfectly when the sheet is unprotected; the problems begin when I lock all
the sheets, for obvious reasons, then I get a message error.

Is there a way to by-pass this; I cannot leave the workbook unprotected, too
many issues will be created.

Thank you for all of your thoughts.