Ok, I have a tricky rpoblem. What I have is a worksheet full of sales
information, for example, col a has the directors name, col b has the
managers name, col c has the store name, col d has the sales value for
store, col e for manager and col f for director. There are 5 diferent

Is there a formula that looks up a value in a cell in another
worksheet, and returns the values immediately next to it?
What I mean is, I have a sheet that looks like this
Col A    Col B    Col C

I've got a workbook with one of the worksheets password protected. When
trying to save the workbook as an HTML file, Excel complains about it
and refuses to do so unless the worksheet is unprotected.
I've tried putting in the call to Unprotect at the Before Close event

Is there a way to show the date and time a cell was changed in the cell next
to it, instead of using track changes and getting the changes listed in a
new sheet or highlited - i want them to be in the next cell.
for instance:

I have a simple question. I use multiple monitors and would like to display
one excel sheet on each without having to maximize the Excel application
window/shell across both monitors.
For example, Word docs open this way by default - each gets its own

I have 100+ rows each with 6 cells (A-F) A & B contain variables which
may or may not change daily and C-F have values produced as follows:
C=A*B, D equals what was previously in C, E=what was in D, F=what was
in E, what was previously in F doesn't matter.

how do i password protect an .xls file? how do i unlock it for automation.
e.g. want to unlock and access a .xls from another .xls macro.

Is there a way to add password protection to all worksheets (same
password used) within a workbook so that all cells within the workbook
cannot be changed.  The workbook has 6 worksheets that are used.
Thanks

I am using W98 and Excel 2K 9.0
Question 1.
On my sheet I print the column letters and row numbers. I have cells
that contain comments such as 'Total of Rows 5 To 8' or 'Row 15 Less

how to automate opening a password protected excel file? e.g. a .xls that
has a password set in the security tab.

is there anyway to make it so the users of my excel spread sheet cant view
the macro code w/o a password?

hi
I want to search for some data in excel and chang the color of th
whole row and this all sould be done with a marcro can any one pleas
help me with that

How do i transfer information on a Excel spreadsheet into a word mail merge
to make labels. I am new at this.

Hi. I am new to Excel (and discussion groups!). I am wondering if someone
knows how I can fix this problem. I have a combobox that uses the linkedcell
property to put a value into another cell. I am protecting the entire sheet
except the combobox. The problem is that this ...

is it possible to execute write to the fields in another .xsl form a macro
in another .xsl? e.g. some way to load another .xsl into an .xsl macro and
write to its data?