Mac Forum / Applications / Excel / July 2007

I purchased Office 2004 student and teachers edition so that I could
do some course work online.  The problem I am running into is the
course has several Excel templates that have macros and I can't seem
to run the macros.  I get the following error message when I try to

How is it a font shows up on my screen as red, but prints black?

I have an Excel sheet which contains a table of projects and a section
of empty cells next to it representing months. I have formatted these
"month" cells with different background colors depending on the status
of the projects. After every data row I have inserted an empty row, so

I need a formula that detects a particular word in a cell, even if
there are more words in that cell.  Example would be =IF((CONTAINS
"word",P3),1,2).  IE: if cell P3 contains the word "word" then 1, else
2. Anybody?

Hi, when i check the box try to activate the add-in data analysis, it
pops-up a windows said " 'FuncRes' cannot be accessed, the file maybe
read-only...", can anybody tell me how to solve this? My excel 2004 is
up-to-date.

We have a Mac OS X server running 10.4.10. On one of the file shares
we set up the Access Control List entry to allow certain users to
create and edit the files but we don't want to allow them to delete
any files. I had a problem with Word 2004 but after modifying

I installed my existing and well used Microsoft Office X on a new
MacBookPro.  Now, opening files from emails or on my desktop no longer
is automatic.  These include files I have had, perhaps created, or
those sent to me.  On my old computer, same software, they opened like

Excel 2004 11.3.5  On intel imac 4.10.10
Is it possible when I close a sheet or save the workbook it will Auto run a
macro to turn off AutoFilter. I sometimes forget to do it and have to reopen
sheet to turn off. I do not want other users to see filtered lists if they

I have been using Excel for years now, Mac OS 10.  Continually, with
or without other applications open, Excel quits for no known reason.
There is no consistency to the process I am involved in and nothing I
do is complicated.

I've been using the Text to Columns command recently and it is driving me
crazy.
Each time I use it, every subsequent time I paste something in Excel, it
parses the contents of my paste to columns.

When I open up excel files I am noticing that the Sigma or the
standard toolbar does not appear even when I uncheck it and re check
it.  Now if I open a brand new document its fine.  Anyone know why
that is?

Private Sub Worksheet_Change(ByVal Target As Range)
The above line is highlighted.  Below is the script.  Why do I get a
compile error name not found?
Private Sub Worksheet_Change(ByVal Target As Range)

I have an excel makro which saves a text file from an marked column.
The Excel File is on a server in the network and so the makro saves
the text file in the same folder where the excel file is (on the
network server)

Hi, i'm able to do this in Windows, but unsure how to translate it to my mac...
how can I get multiple lines of text in one spreadsheet cell?
I am able to do the format>cells>wrap text. But I want to be able to insert
a new line, ie a list.

Hey folks, here's my query if anyone can help:
I've got a spreadsheet with one column in it containing organization
names and addresses. Some cells start with the address - specifically
the street number - and some rows start with the organization name.