I am working on a workbook which has the VBA editor lock by a password.
so I can't write or see VBA code.
but what I would like to do is being able to write some quick VBA in
the function bar.

While doing a lot of data manipulation
and additions, linking to Access and so
on I've noticed the size of the .xls file
has almost doubled - compared to a backup

I have over 100 sheets in my workbook & need to refer to the sheet name in a
cell on each worksheet.  I created the following function:
Function sn()
   sn = ActiveSheet.Name

My problem is:
I have a sheet1  to sheet10 with class marks created for each class and i
have other sheets created for each studen. and some times i need to paint the
cells with a diferent coulor and the problem is when a paint a cells i need

Can someone give me the exact code for the following general situation:
If the active worksheet when a macro is called is sheet 1 or sheet2 or sheet3, then hide row 16.  Or, if sheet 4, hide row 18.   If any other sheet, don't hide anything - that I suppose requires no text!

Hope somebody is able to help me on this small problem.
I am trying to return a cellvalue from a closed workbook using a
function.
The code that I've used is as follows:

i am simply trying to open a dbf file then close it without doing
anything and do not want to  notify the user plus if any message comes
out i want to ignore it...(opening in the background)... i tried with,
   'fileToOpen = "c:/path/musa.dbf"

I'm opening excel from Outlook and copying a recordset in that has 80
semi-colon separated values into cell a1.  I want to use text to columns
after doing this.  I select the column in the code which works fine, but the
code i recorded in excel to perform the text to columns ...

Is there anyway to check the excel version from the macro?
Is there any predefined variable for the version, or
do I need to check Windows registry?
Regards,

We have a big spreadsheet here at work with about 40 columns.  One of
them, let's say it's column H, contains the names of some school
districts. Some of them occur more than once in that column.  Column I
contains that district's code number. Another column, say column N,

This should be so simple, but I'm struggling.  I want to sum a column of
contiguous numbers and put the total in the first empty cell beneath them.  
The number of cells summed varies depending on the column.
When recording this and reviewing the code, the VB Editor gives me the

HOW TO RIGHT A FORMULA TO HAVE NUMBERS APPEAR IN ORDER SEQUENCE

I am filling in a form letter in Word using data from my excel worksheet. I
am using Formfields which I am new at. I know how to reference a specific
bookmark name like:
Dim appWD As Word.Application

Hi guys, hope you can help
I got a strange request, is it possible to change the color of a value
in an input cell after a value has been entered, based on a simple
subtraction formula?

I've set Application.OnKey "{F12}", "" in my workbook's open method.
It disables the F12 key fine, until I double-click a cell to edit
directly in a cell.  F12 becomes functional at that point.
Any suggestions on disabling a key whilst directly editing a cell?