Mac Forum / Applications / Excel / November 2005

Can anyone tell me how I add a menu item in a single workbook without
it becoming part of the template for all other workbooks?  I would also
like the menu item to be visible to any others receiving the workbook.
Many thanks,

Is there any way that you can go backwards and recover a file after you
have already saved changes (I accidently deleting 15 rows of data)

G'Day Mates,
My dilemma is that row 1 has a height of 7 to accommodate for a dashboard
of formulae (Subtotals etc for my database). As the header list is also in
row 1 and formatted> vertical> bottom> wrap text. If I type Sales 2004, when

Apart from going to each cell and clicking ŒIgnore error¹ can I cancel/hide
all these green triangles in the top left corner of many cells?
And, having done something I wish I had not how can I get rid of the
annoying arrow with a blob at the other end drawing attention to my ...

Looking for some help here. I am running Pather with Excel Mac 200
(11.2). I am prompting the user to select a file to open, and want t
restrict the file type to Excel spreadsheets with the filefilte
command.

Is it possible to rename a Worksheet using a macro? I am running a
macro to move a data sheet to the far right. I would then like to run a
second macro to rename the sheet by copying and pasting a cell value
from within the sheet. i.e. the sheet has the word October in it. I

Using 2004 11.2, Tiger
How can I use MODE in a filtered database. Each time I filter I would Like
to see the most common denominator (value only) in a column. For other:
sum,average,count and max I use subtotal. I am Stymied with this one!

I have just encountered a problem trying to preview and print a sheet I
have created in Excel 2004 for Mac.
When I try to print I get an input error message:
'The number must be between 1 and 32767

I need to change the default currency from euro to $ , i change the settings
in the "international" preferences on my control panel (OS), but excel still
using the euro currency.  The same thing with the decimal point, excel use a
coma instead a point.

I thought this would be a FAQ, but it turns out to be a FUQ (frequently
*unanswered* question)...
I am creating a web-metrics dashboard for a client using Excel X (on
Mac OS X 10.4.3). I try to be a good cross-platform guy, so I used

With Excel 2004 11.2, I encountered repeated problems with a particular
large spreadsheet with multiple tables in it. Every time I changed
anything in the sheet, Excel crashed.
I removed Office, using the remove office utility, and reinstalled up

I use VBA extensively in Excel on both a Mac and a PC. Recently I added
a lot of code to a particular worksheet and it works fine on the PC,
but when I try to execute on the Mac, I get a "procedure too large"
error.

I have a client who has finally come into the 21st century and needs to
convert her old Hypercard address books to something that runs natively
in OSX.  I've been looking for a nice applescript to convert the
Hypercard stacks to Excel spreadsheets but am having no luck.

I have created a commandbutton in Excel (on a Mac) and cannot figure out
how to change it's caption or delete it. On a PC I can right click to do
this but the Mac mouse has no right click.

With OS 10.4.3 installed on a G4 1,33 GHz PowerBook I created an Excel
template with our companies logo integrated as png picture in the page
set-up header. After storing the template I duplicated the xlt-file twice,
renamed it to worksheet and workbook and stored these files inside ...