Colin Hayes laid this down on his screen :
In article , GS writes
Colin Hayes pretended :
...I just want my answer to the first Yes / No prompt to be
implemented to all sheets in the workbook rather than be asked for a
decision on each one in turn. In the calendar project which we were
discussing this means 12 popups boxes every time. I was hoping it
would be a simple thing.

So then, to achieve this more easily, move the iteration into a
front-loader sub and ask the Q there 1x. Revise your protect proc
accordingly. I think you'll be happier with this approach! (If I get
time I'll modify the calendar project to demonstrate this and email a
copy to you)


Hi Garry

Yes , thank you. That would be very kind.

The protect unprotect macro I have been using , and seek to modify , is not
specific to any workbook. It protects / unprotects any open book you run it
on.

I was seeking a modification whereby a popup would request whether the user
wished a more sophisticated protect with specific permissions , or a simple
one. The Yes or No answer would provide this and act accordingly on all the
sheets in the workbook. It's just a generic macro. I see entirely what you're
saying , and agree with the modifications you suggest but modifying specific
workbooks to match the macro kind of defeats the generic integrity doesn't
it? Or do I have this wrong?

^_^


Best Wishes

Giving the user permission options is the way to go <IMO. Albeit they
can use the Excel dialog to do this but that means they get to use
their own password (if any). Having our own substitute for the built-in
dialog gives us the best of both, leaving the password issue to our app
only.

Your interest to go this route has inspired me to update my own proc
how I've been wanting to, but never made time to do so. Now I have an
excuse! I think you'll get the idea after you see the sample...

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc