take user clik as an input
 

Hi
I'd like to run a macro in a new sheet is inserted and the user is asked to
name a new sheet, how can it be done?

take user clik as an input
 

Sub askfornameofsheettoinsert()
myname = InputBox("Enter name of new sheet to insert")
Sheets.Add
ActiveSheet.Name = myname
End Sub


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Yossi evenzur" wrote in message
...
Hi
I'd like to run a macro in a new sheet is inserted and the user is asked
to
name a new sheet, how can it be done?