Floating Key
I would like to create a floating key that allows users to view a simple drop
down box that shows them what task they should be inputting on a worksheet. The drop down box needs to be visble on opening and float at the top of the worksheet like a toolbar can. Then the user can click the drop down button and a list of 20-30 tasks will appear with a code that can used to fill in the spreadsheet. eg. in the dropdown box will be:- 1. Open Mail 2. Frank Mail 3. Filing 4. Plan Printing They'll know No.4 is for plan printing and add that code number to a cell. I was going to put the key at the top of the worksheet but as I have frozen some rows and columns, this key would disappear. Any ideas? |
Floating Key
Any ideas?,
You could create a list of your tasks on a spreadsheet and then use the "Watch Window" to display them. See Tools | Formula Auditing | Watch Window. Also read Excel help under "Watch a Formula" Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware "Mr-Re Man" wrote in message... I would like to create a floating key that allows users to view a simple drop down box that shows them what task they should be inputting on a worksheet. The drop down box needs to be visble on opening and float at the top of the worksheet like a toolbar can. Then the user can click the drop down button and a list of 20-30 tasks will appear with a code that can used to fill in the spreadsheet. eg. in the dropdown box will be:- 1. Open Mail 2. Frank Mail 3. Filing 4. Plan Printing They'll know No.4 is for plan printing and add that code number to a cell. I was going to put the key at the top of the worksheet but as I have frozen some rows and columns, this key would disappear. Any ideas? |
All times are GMT +1. The time now is 07:04 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com