would like shortcut to jump back and forth between worksheets

[pathfinder2000]

on a Mac... and want to be able to shift back and forth between two worksheets... the control uppage does not work.. I can right shift and see the list but I want to go back and forth between where I am and the last worksheet I was on like a toggle. How would I do that?

 

[DonkeyOte]

If you're not running XL2008 and thus have VBA support you could try something along the lines of the below, within ThisWorkbook object:

Dim wksPrior As Worksheet

Private Sub Workbook_SheetDeactivate(ByVal Sh As Object)
    Set wksPrior = Sh
End Sub

Public Sub PriorSheet()
    If ActiveWorkbook Is ThisWorkbook Then IIf(wksPrior Is Nothing, ActiveSheet, wksPrior).Select
End Sub

the above is c/o shg @ http://www.excelforum.com/excel-2007-help/709172-excel-shortcut-switch-to-previous-sheet.html

I believe that the Mac versions will be based on VB5 rather than VB6 so the above might not work irrespective of 2008 (I don't know if any of the above would fail - I've no VB5 based version against which to test)...

So all in all I confess the above is all something of a "punt in the dark" in your environment... I hope a Macster out there can help ?

 

[pathfinder2000]

Thank you for your response. Unfortunately I have no idea how to change code in Excel. If you could explain to me how to do this perhaps I can try it.

 

[mike31z]

Here is a short macro that I use to jump between worksheets in the same workbook.

It has three values that need to be changed to matck your needs.

Sub gotoButtons()
'
' gotoButtons Macro
' Macro recorded 18-05-2007 by Mike
'

'
Sheets("Buttons").Select
Range("A1").Select
End Sub


The three items that need to be changed are First:
"gotoButtons" just after Sub on the first line. This is the name of the macro that will be displayed in you Macro List. (alt+F8)

Second is "Buttons" change Buttons to the worksheet you want to go to leave the " ".

Third is "A1" this is the cell on the worksheet that you want to goto.

That it, then you have to create a button from the Forms Toolbar and assign the macro you just created.


Mike in Wisconsin