Mac Forum / Applications / Excel / April 2005

I have no macros at all in an Excel 2004 for Mac workbook. But
everytime I open the file I get the Macro warning asking if I want to
enable / disable Macros. This is really annoying. I am sure I have no
Macros because nothing appears whe I click tools->Macros. There are no

I have a check ledger program that the data in the cell can be either a
date or a check number. When I enter the date, I would like for it to
come up as 4/26 and not 26-Apr. Is there a way to make Excel use a
different format than the 26-Apr format? The cells are defaulted to

I am using Office X for Mac, SR 1.  AutoRecovery is turned on in both
Word and Excel.
AutoRecovery works for Word but not Excel.
I find that the AutoRcover saved Word document is in the Microsoft User

I am looking for some help in translating some old Excel files.  I am
running Excel 98 on a Macintosh OS 8.6.  The program won't convert such old
files.  I am getting little help from utilities like Can Opener, etc.  I
will take a look in a few days and see if there is any help ...

i have been working on a large database and suddenly I get a message
saying: unable to sort because operation requires merged files need to
be identically sized. I have no idea what this means. I can sort parts
of the file but not the whole thing so somewhere a piece is corrupted

[version - Excel 2004, OS X 10.3.9]
I¹ve searched this newsgroup¹s archives and learned that saving a new
Workbook in the default startup location should very easily solve the issue
of default zoom and window size and location on the screen (as I¹m using the

I'm having trouble with spreadsheets downloaded from the internet.  It
appears that Excel makes changes to DATE-TIME data in spreadsheets.  It
shifts the dates somehow.  Has anyone seen this behavior?  Does anyone have
a resolution?  I have visited the Mactopia website with no ...

I'm using Exel 2004 (Macintosh version). Excel offer a tutorial in
using the list manager in the Help menu.
In this tutorial  the example show how to define the columns and enter
data. This is all fine.

Hello, I share excel documents with my smart phone which uses the
symbian OS. I can exchange all office doc types (word, ppt) except
excel. when I bring an excel doc from my pda to my mac office 2004
excel can't open it. I believe the fine is in a format known as mhtml

I am trying to use two colors in a drop down menu in an excel
spreadsheet.  I have the data in the two colors, but the drop down only
appears in black.  How do I make the color formatting of the data
appear in the drop down?

I am so fed up with this.  You have a number , and you click and you drag to
the cell underneath.  Sometimes the number stays the same. Sometimes it
increases by a value of one.  Sometimes in you click shift or option in
stays the same or increases by value of one.  I've seen so ...

Is there a way I can get a userform to run without having to open up
the VB editor and run it.  More specifically, I would like to get the
userform to run when I open up the Excel file it is in.  Right now, I
have to open up the Excel file and then open up the VB editor and then

Why don't the F keys work in excel mac, and some of their functions. I
got somewhat used to doing CTRL-U instead of F2 although the benefit of
using two fingers rather than one escapes me, but i am even more
frustrated about the inabilty to paste name by using the key F3 while

I'm looking for a way to format a cell range (let's say {A1:B6}) as number
without decimals (integer number) via AppleScript.
Anybody can help me?

I just switched to Mac and love it, particularly my PowerBook.  I also have
a desktop PC, so I run MS Office on both.  I have to say, the menu and
toolbar system in Office 2004 Mac is big and clumsy compared to the one for
Office 2003 PC.  Not only are the toolbars twice as ...