I've written some code that makes changes to a protected
sheet. Therefore it had to be unprotected. I know that
in 97 the problem is that it is confused about what has
the focus so you need to activate the sheet and possibly
the active cell. The problem this time is that at that
point of the program 2 sheets are seleted. The only
soloution I came up with that seems to work is to have the
program select a different sheet then select the sheet I
want to unlock, unlock it make the changes, lock it,
select the 2 sheets again. This is not a great soloution
since the program repeats this a number of times, printing
the 2 sheets, making some changes then printing again.

Is there a way around this, like an unselect command for
one of the sheets or a way that I could unprotect a page
even when 2 sheets are selected.

Thanks in advance for any help.

Wes