Validation question
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
|