Mac Forum / Applications / Excel / March 2005

When calling a procedure from within another procedure is it proper form to
use "Call" with the procedure name or just specify the procedure?? Or is it
just personal preference??
E.g.

Excel seems to keep numerical cell data as 8-byte values. This introduces
some conversion errors when calculations are made in VBA using 4-byte
variables (type Single). Using 8-byte variables (type Double) is preferable
to get accurate results. See the following procedure for a ...

Is there a way to set the default magnification when you OPEN documents in
Excel? I find frequently in Excel 2004 that when I open an XLS file from a
Windows user via email, the magnification is at something like 50% and the
window is ³squeezed² into the upper-left corner of the ...

I do a lot of managing distribution lists in excel before exporting
them to a FedEx shipping computer in space delimited files.
While double clicking to edit data, I sometimes will accidently double
click inbetwen rows, this brings me to the end of the document.

I am fairly new to VB and I had a question about listboxes.  If I have
a multi-row, multi-coolumn listbox and I want to read the value out of
a specific cell of that listbox, how can I do that.  I have tried
reading ListBoxName(j,k).text into a string and I have tried reading

Can anyone offer assistance with the reason the following does not
work:
' Procedure in TestWorkbook.xls
Sub UpdateStatus()

I teach at a mostly pc university so in my labs my students use pc's to
write reports and I frequently have to transfer them to my mac.
Sometimes excel charts in their papers come up as big red X's on my
mac.  In one paper I'll get one chart okay and one chart is an X, so

Hi Folks! :)
Just a quick question...  Can I make page borders in Excel like in
Word, or can I apply borders only to cells?
Thank you!

I seem to lose the customizations I add to my toolbars when I quit
Excel. Any ideas? Thanks.

A portion of code inside a form has suddenly started misbehaving in Excel
2004 v 11.1.0. The same code works without problems in Excel X & 2001 and
has worked OK in 2004 before.
* The code is located inside a form.

In Excel for Windows, it is possible to edit the icons on toolbar
buttons, but I cannot find similar on Excel for Mac 2004.  I see that
you can select from some preset choices, but I want to design my own.
Any tips appreciated.  Thanks!

My PDF Maker toolbar has disappeared from Excel 2004. It does not show up in
Tools->Customize->Toolbars. Both Word and PowerPoint 2004 have it. Is it
possible to re-create it, or do I need to install Acrobat 7?
Hardware:

In the Windows version of Excel when writing a procedure helpful
syntax/object tags appear when a line or object or function is started.  I
find it really helpful since I don't memorize the syntax of properties, e.g.
Find.  I don't get the same tags in the Mac version, is it ...

I use Excel (Office X with OS 10.3.7) to keep track of employee
attendance.  I have about 6 workbooks set up with any where from 5 to
80 sheets per workbook (depending on the department).  I also have a
master sheet with generic information on it.  These worksheets are on a

I recently found out how to read values from a sheet in another closed
workbook using the GetValue function I have pasted below.  It builds a
string and then calls ExecuteExcel4Macro to return the value from the
other sheet.  In my application, all the values in the sheet being read