Active Range Class Error

[xjohnson]

Hi when running code to protect workbook I get a message which says "Please revise the entry in A1. It appears to contain one or more illegal characters."

Then it goes to debug but a different sheet each time.

Does anyone know why this is happening?

Thank you

Please Login or Register  to view this content.

[TMS]

That routine will fire every time you select a different worksheet. It's your message that is being displayed and presumably it means it doesn't like whatever is in cell A1 on one or more of those sheets.

Difficult to be definitive without seeing the workbook.


Edited to reflect cell A1 rather than cell A31 (my mistake)

[xjohnson]

Can you take a look please?

[dominicb]

Good afternoon xjohnson

Want to share the password with us? Not impossible to do it without, but it makes life easier.

HTH

DominicB

[xjohnson]

Sorry it's "password"

[dominicb]

Hi xjohnson

The code for the protect module works OK on its own. In running it fires the "Worksheet_SelectionChange" module which forces an error which shows the error code.

Get rid of this module and it seems to work OK.

What is the purpose of this module? I can see what it's trying to do, but not why it's there.

HTH

DominicB

[xjohnson]

I have been developing over time I think it's to name the sheet tabs from cell A1

[xjohnson]

Yes it is to name the sheets which I still want the ability to do so.

Can it be modified or perhaps another way to name the sheets from the 'Vehicle Information'! sheet?

[dominicb]

Hi xjohnson

If you don't know what it's for, do you actually need it? Why does a tab need renaming every time a user selects the sheet?

For now, comment out all the code in that module and see how things run without it. If you remember why it absolutely had to be included, then post back with more details about what it needs to do and why it needs to do it and some of us will help out with suggestions.

HTH

DominicB

[xjohnson]

I found another workbook that I was using for this:

Please Login or Register  to view this content.

It works fine now sorry for the trouble guys.

[TMS]

You're welcome. Thanks for the rep.


The difference is that the last code module sits behind a specific worksheet and, when a change is made to cell A1, it will update the sheet name.

The code module in the OP sits behind the workbook and fires every time a sheet is selected ... and changes the sheet name based on cell A1 (my mistake in my original response)