On Dec 10, 9:21 am, jnf40 wrote:
Ok I checked the code and I can reformat the cells without selecting them,
however is there a way to lock and unlock cells without selecting them? I
have tried what I know and I get 'Unable to set the Locked property of the
Range class' message.


If the sheet is protected then you'll have to unprotect it before
unlocking the cells and then relock it.

Tim





"Tim Williams" wrote:
If you're referring to code you wrote to perform the reformatting:
there's no need to select a cell to reformat it.
You could post the problem code for suggestions.

Tim

On Dec 7, 2:23 pm, jnf40 wrote:
I have a Userform that pops up when a cell is selected. Is there a way to
have the Userform NOT pop up if the cell is selected with code that reformats
that particular cell?- Hide quoted text -

- Show quoted text -