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
 
How does one get "Shared Workbook" to share faster than every 5 minites? I'm looking for a sharing update every 15 seconds or so.
 
Upvote 0

Excel Facts

Can Excel fill bagel flavors?
You can teach Excel a new custom list. Type the list in cells, File, Options, Advanced, Edit Custom Lists, Import, OK
ActiveWorkbook.AutoUpdateFrequency = 1

You can override the 5 min limit by putting this in the startup event.
 
Upvote 0
I've just been been able to get back to this project.
Sorry, for my stupidity Joe, but exactly how do I add this 'AutoUpdateFrequency' statement to the "startup event". I'm sure it's simple, but I haven't been able to get it to work. I'm using Excel 97.
 
Upvote 0
Sorry, 5 minutes is the shortest update to sharing!
I thought the code would be in seconds, but alass it is minutes.



Private Sub Workbook_Open()
'ThisWorkbook module code, only!

'The AutoUpdateFrequency property must be,
'a value from 5 to 1440 minutes, only.

ActiveWorkbook.AutoUpdateFrequency = 5
End Sub
 
Upvote 0

Forum statistics

Threads
1,215,586
Messages
6,125,687
Members
449,249
Latest member
ExcelMA

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