Make a custom excel file work on a mac?

[Kram]

Greetings,

I have a specialized spreadsheet that was done for me by someone in Excel
for windows. I'd like to use it on my mac but I need the numeric "enter"
key to advance to the next cell in the 'column' (down) and instead it
advances to the next 'row' (across to the right).

In all other respects it works fine.

This was a special order spreadsheet that I'm guessing has a lot of visual
basic in it.

Is there anyone out there who can make it work on a mac for me? I'd be
willing to pay a modest amount if you can make it work for me.

Thanks,
Mark
(e-mail address removed)

 

[J.E. McGimpsey]

Greetings,

I have a specialized spreadsheet that was done for me by someone in Excel
for windows. I'd like to use it on my mac but I need the numeric "enter"
key to advance to the next cell in the 'column' (down) and instead it
advances to the next 'row' (across to the right).

In all other respects it works fine.

This was a special order spreadsheet that I'm guessing has a lot of visual
basic in it.

Is there anyone out there who can make it work on a mac for me? I'd be
willing to pay a modest amount if you can make it work for me.

See

http://www.mcgimpsey.com/excel/enterkey.html

You'll need to use a macro, so substitute this:

Application.OnKey "{ENTER}", "EnterDown"

and copy this macro to a regular code module:

Public Sub EnterDown()
Dim firstRow As Long
Dim lastRow As Long
With Selection
If .Count > 1 Then
firstRow = .Cells(1).Row
lastRow = .Cells(.Count).Row
Else
lastRow = Rows.Count
firstRow = 1
End If
End With
With ActiveCell
If .Row = lastRow Then
Cells(firstRow, .Column).Activate
Else
Cells(.Row + 1, .Column).Activate
End If
End With
End Sub