Bob:

This is new to me. I checked it out, and I probably should have been using
this option for some of my applications. Seems like there is always
something to learn!!!

--
Rich Locus
Logicwurks, LLC


"Bob Umlas" wrote:

The first thing your macro should do it protect all the sheets with the
parameter "userinterfaceonly" set to true. That way, you're marking the
sheets as protected, but NOT for VBA stuff.
Alternatively, you can have the macro unprotect before it starts &
reprotects when it's done.
Bob Umlas
Excel MVP

"chris felix" wrote in message
...
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.

.