Mac Forum / Applications / Excel / January 2006

I am trying to sort a list to look the following:
350
351
351a

I created a custom Excel Toolbar with VBA. It worked in Windows Excel, but
the buttons failed to load in Mac Excel. Can someone help me to find what is
wrong with the code?
Thank you very much.

I built a custom tool bar for my applicatoin. It works ok on PC Excel. But I
got an error message on a Mac Excel:
Run-time error '-2147483640(-7FFFFFF8)':
Method 'FaceId' of object 'CommandBarButton' failed

I am attempting to write Applescript code to copy a table in Safari and
paste special it, as text, to an
Excel worksheet.
When I perform the operation manually, all the rows of the Safari table

Is it mandatory that the merge field names (I want to be able to merge data
into a Word document) be in the first row of the Excel spreadsheet?
I have an excel sheet that contains student testing data.  I've added a
couple of rows at the top--one to give the spreadsheet a title and ...

I recently swithced to Mac and had developed a lot of files with VBA
Projects in PC Excel 2003, which I locked and password protected.  When now
opening it with Mac Excel 2004 everything works, I can see the various
modules in the project under the Macros section in Excel, but I can ...

Is there any way to format the cells to treat info as Distance (10' 3")
?  i know there is accounting and date.....  
Thanks

When I scroll down, or hit END, I want the sheet to stop at the last
row and when I scroll to the right, to stop at the last column.  I
could do this for Excel Windows but not sure how to in Mac.
It was a combo of highlighting the document and using ctrl shift delete

Excel goes into an endless loop when trying to open a new document. It
can open documents, but also goes into endless loop (no reaction) after
selecting a cell and trying to copy its contents (cmd + c).
I already cleaned all system caches, does anyone have an idea?

I'm using Get and Let methods on an Objects Private Variables called
for eg: OrdSettleDate , etc in my VBA App.
In my debug mode, when I watch the built up object I see two
occurrences of the variables, in the object - OrdSettleDate and

I want to tell excel to delete a row if a certain phrase occurs in a
cell in that row.  Is that possible?

I'm new to Excel for macs, and have a question.  I'm using Mac OS X
10.4.3 and Excel 2004 for Mac, version 11.2.  My problem is that I have
created a xy scatter chart with dates on the x-axis, but I can't change
the alignment of the dates from horizontal to vertical.  When I go to

I would like to merge several worksheets within a workbook.  I want to keep
the columns separate and not merge all into one column.

I recently swithced to Mac and had developed a lot of files with VBA
projects, which I locked and password protected.  When now opening it with
Mac Excel 2004 everything works, I can see the various modules in the project
under the Macros section in Excel, but I can not get into ...

How do I protect column headings at the top of a spreadsheet so they are
visible no matter how I far down scroll? In earlier versions of Excel there
was a PROTECT command under TOOLS that did it. In Excel X there is
PROTECTION, but I can't figure out how to lock the top row and only ...