| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| EXCEL 2007 Right clik options not working | Excel Worksheet Functions | |||
| Prompt user for input and utilize that input | Excel Worksheet Functions | |||
| Have user input converted to uppercase in same cell as input? | New Users to Excel | |||
| excel will not open a file with a double clik on a icon | Excel Discussion (Misc queries) | |||
| CODE to select range based on User Input or Value of Input Field | Excel Programming | |||
![Yossi evenzur[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
