Can someone help me with a 'macro script' on how to hide a Menu Bar
(File/Edit/View/Insert/Format etc).
I just want to block people from using the functions in Menu bar.
Thank you so much.

I have a user that constantly tells me he receives an error stating
that an excel workbook is already open when it is not.  We look at the
list under 'Window' in the menu bar, move all of the minimized windows
out of the way, and we cannot find these files that are supposedly

Please can anyone tell me how I can place in a cell on a sheet the date the
workbook was last modified?
Thanks
Shane.

I ended up writing this function In an attempt to get the number of
rows used in a worksheet. I tried using Rows.Count but it did not work
(unless I was doing something stupid).
This function does work, but I can't help wondering wether there is a

I wish to reset the properties of several worksheet controls on the
entry into a cell. The visual basic help suggests using
Sub Worksheet_Change(ByVal Target as Range)
End Sub

I'd like to know if it is possible to only enable certain cells or parts in
the workbook, where you can write and rest, especially parts where you have
put formulas, to be locked,or make it skip on those cells, or for that matter
the rows.

Thanks Roger, just what the doctor ordered, works fine.
Even though I'm now using your formula, I'm afraid I don't understand it or
how it's doing it.
How would you modify the formula to act only on a range of cells (B1 to

I have chosen to hide the Menu Bar.
How do I let users save their work?
I plan to create a button and assign a MACRO to it so that users can click
and 'SAVE AS' their file by first typing in the file name. Can someone come

Never noticed that before: Undo and redo are unavailable after applying Auto
filter. Is this a  known issue or something's wrong with my copy of Excel
(or system)?

Please forgive what might be a beginner question.
I have a spread sheet that is made up of 10 columns.
I would like to make it so that each time I change a
number in these columns, the sub-total at the bottom

Was looking for a way to have excel format evey other or every two lines in a shadded format instead of having lines (borders) on the spread sheet.
Any suggestions....
Lenny
EggHeadCafe.com - .NET Developer Portal of Choice

how do i size the cells in excell to organize alphabetically

I have a spread sheet that is made up of 10 columns.
I would like to make it so that each time I change a
number in these columns, the sub-total at the bottom
of each column changes automatically AND so that

I have some cells that look like this:
$10 red
$4  Blue
$13 Silver

In cells A1 and B1 I have the following data:
4,5,6,7     4,5,6,7
In B3 I want to count the number of non-matching combinations.
The answer is 12.