| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Prompt to enter a macro name?
Dear Experts:
Whenever I run this macro a dialog field pops up asking me to enter a macro name. Why is this so? Sub Worksheet_Change(ByVal Target As Excel.Range) If Len(Range("E4")) < 32 And Range("E4") < "" Then ActiveSheet.Name = Range("E4").Value End If End Sub |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro to enter a value, tab to next cell in the row, enter ... | Excel Programming | |||
| Macro to enter a value, tab to next cell in the row, enter ... | Excel Programming | |||
| Macro to select cells in column enter data then press enter | New Users to Excel | |||
| Macro prompt | Excel Discussion (Misc queries) | |||
| Prompt User to Enter Data with a macro | Excel Programming | |||
Threaded Mode
