It only has to be done in xl97, but it doesn't cause a problem in other
versions - so you don't need a separate code base for xl97.

--
Regards,
Tom Ogilvy

"norman1nz" wrote
in message ...

Tom Ogilvy Wrote:
If you are calling this from a commandbutton, then change the
TakeFocusOnClick property to false

If it is another type of control from the control toolbox toolbar, then
as
the first line of code in the event, place

ActiveCell.Activate

--
Regards,
Tom Ogilvy



Thanks for the tip
Does that only need to be done for Excel 97? Strange. Because it works
fine without activating a cell before protecting in 2000/2003. I will
try this tonight


--
norman1nz
------------------------------------------------------------------------
norman1nz's Profile:
http://www.excelforum.com/member.php...o&userid=27155
View this thread: http://www.excelforum.com/showthread...hreadid=476660