Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Validation Question | Excel Discussion (Misc queries) | |||
Validation question | Excel Worksheet Functions | |||
Validation Question | Excel Worksheet Functions | |||
validation question | Excel Discussion (Misc queries) | |||
Validation Question....Can this be done? | Excel Discussion (Misc queries) |