Validation question
You can put in about any valid formula in data validation, so if you come up
with a formula which checks for all the invalid characters, then you could
us validation. In you event, you would have to just remove any invalid
characters or clear the cell and not rename the sheet or something like
that. I am sure you will receive other ideas as well.
--
regards,
Tom Ogilvy
"Adam" wrote in message
...
I have worksheet_calculate even that changes the name of the sheet tab
depending on cell D4 wich contains "OF_"&B4
Is there any way to set validation on cell B4 so that it is not possible
to
insert symbols that are not accepted as sheet names as - * etc. or is it
possible to prevent this in the event code. The code is as follows
Private Sub Worksheet_Calculate()
Me.Name = Range("D4")
End Sub
Thanks for any help
|