| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
List box activated on opening file
I'm would like to set up a listbox so that when a file is opened the user is
asked to select the current period forecast. I have a named range called "forecasts" which contains the forecast details. Once they have chosen I would like the value they have selected to go into cell B2 on a worksheet called "Forecast" I would then want to move to a sheet called "Opco Sheet by KPI" Is this possible? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Weird File Open/Save As Behavior | Excel Discussion (Misc queries) | |||
| How to stop a file from opening when XL starts? | Excel Discussion (Misc queries) | |||
| zero suppression on opening .xls file | Setting up and Configuration of Excel | |||
| Very slow in opening Excel 97 file in Excel 2003 | Setting up and Configuration of Excel | |||
| Weekly Transaction Processing | Excel Worksheet Functions | |||
Hybrid Mode
