List

paitchison

New Member
Joined
Apr 28, 2003
Messages
10
I am a relative beginner at Excel (compare to many that inhabit this board). I am setting up a 'Snack Shack' "point of sale / order fill" spreadsheet to be used in our church kitchen (Holy Grille). I need all of the relevent current information to remain visible on the main screen.

I am using Excel 97, and a Winows 98 PII laptop computer with a remote monitor and wireless mouse. This allows the cook staff to enter data when orders are filled.

My problem is that the "List" function (Data/Valadation/list/source) will not work above the Window/Freeze pane. It works perfectly below the Window/Freeze pane. Can the "List" function be enabled to work above Window/Freeze pane as well as below?

The spreadsheet is working out just fine otherwise.

Many Thanks Paul
 

Excel Facts

Which lookup functions find a value equal or greater than the lookup value?
MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.
Okay.... Is there a work around, update or fix available to this anomally. A solution would surely make life easier for the kitchen staff at The Holy Grille.
 
Upvote 0
Can you maybe split the screen rather than freezing it? I don't actually know if this will solve the problem, but I believe the 97 issue only relates to when the pane is freezed.

Failing that, upgrading to a later version of Excel would solve it.

Best regards

Richard
 
Upvote 0
paitchison

Welcome to the Mr Excel board!

As far as I know there is no 'perfect' solution, but some possibilities are:

1. Can you move the Freeze Panes down a bit more to allow room for the drop-down?

2. Can you move the drop-down up any further (eg from row 4 to row 1)?

3. Combination of 1 and 2.

4. The other solution that I have seen used (using VBA) is when the drop-down cell is selected, remove the Freeze Panes and when the drop-down cell is de-selected, re-apply the freeze panes. If this seems like a possibility for you, post back and I am sure one of the VBA gurus will be able to help with this.

5. Upgrade to a newer version of Excel.
 
Upvote 0
Thanks people. I've opted to use split screen. While not 100% what I was after, it will do just fine. Thanks again.

Another newbie question. How can I get Excel to beep on a given cell?
My cook staff are after me to notify them when a new order is placed.
 
Upvote 0
Just add this to the Sheet Module for the Sheet that you want it to beep on!

Workbook Sheet Tabs: Right Click, Select: "View Code" and Paste a copy of this code in that code module.

To return to your Sheet select the upper-most-Right-Close X



Private Sub Worksheet_Change(ByVal Target As Range)
Beep
End Sub
 
Upvote 0

Forum statistics

Threads
1,213,501
Messages
6,114,010
Members
448,543
Latest member
MartinLarkin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top