Mac Forum / Applications / Excel / March 2006

I have few worksheets in a workbook.  I try to write a formular to lookup a
value from a worksheet named "Open-3035". The formula will look like "
=HLOOKUP($B$1,'Open-3035'!$C$4:$N$28,25,FALSE) "
However, my formula has to change the worksheet's name sometime.  Therefore

Gang,
I have a list using List Manager.  For the second time, I've been
greeted with the error message "Cannot shift objects off sheet" when I
try to simply hide a row.  This happened before, and the problem went

I have found a macro to convert a list of names which are in to but I need
one to covert to 'Proper Case' since it is necessary to maintain the capital
first letter of each word
In anticipation - thanks once again

I share my files with others in a MAC only environment. Me as the
server, saves an Excel document for others to use. When they open them
over the network, they are opened as "read only" how can I prevent this
from happening. I want them to be able to edit the documents.

In many on my documents, I have random rows that are printing too light.
Real weird.  Like 70% or rows prints great, rich dark black, and then like
10-30% or rows print very light, and faint, and often cracked in middle.
Usually happens with small fonts like Geneva 9 or

My question concerns copying a formula in a cell that refers to another cell
using relative references, then pasting that cell and it's formula to another
cell and maintaining the correct relationships.
Suppose cell (10,10) refers to cell (9,9) using formula =R[-1]C[-1].

During the download and installation of Row Liner, it placed the .xla
file on my desktop (iMac G5, Tiger, XL 2004).  It installed and worked
perfectly. *But* I moved the .xla file into the MS Office folder to
clear off my desktop and now XL comes up with a message that says it

Does anyone know how to export comments to a word document?  I searched
the forum and tried to run an old Macro that someone had written.
However, I get syntax errors when I try to run it.  They are not
specified.

We do monthly sales reports by sales person/by item. I have another
spreadsheet that lists the certain items that pay a bonus back to the
sales rep. This changes several times throughout the year. How do I
"combine" the two so that the items sold will automatically list the

How can I change the sounds effects?
Under preferences I can't see any options.  Is it somewhere else? Is it
even an option?

Using Microsoft Excel X (at home) and 2004 (at work) I am trying to
copy rows of data from worksheets in one workbook to columns in
worksheets in another workbook while using the transpose and paste
values command under pastespecial. I tried to make a macro to do this

I just a new job in an office that uses only Mac's.  I have been using Excel
for PC's for years and can make pivot tables fairly easily.
However, Excel 2004 for Mac does not seem to want to play nicely.  When I
create the PT, only the Page items have a drop down arrow for selection.

How do I insert a greek character, specifically theta, into a cell
without using Microsoft Equation to do it? I have seen it on the
Windows version of Excel under the Insert menu and then selecting
Symbols, but I have not found that on the Mac version of Excel.

When I display the month via MMMM, it returns the month as January,
Feburary.....
I would like it to be displayed as JANUARY, FEBURARY. Any thoughts?

What am I doing wrong?  I record a macro using a simple page up, and
then a tab, and it doesn't work at all.  Nothing happens, plus, I once
closed the little "watch" pop-up toolbar window, and it never came
back.  That little square?  I'm on a mac powerbook running 10.4.5 and