Global Group
 

Can I work in Global Group in Excel?

Maybe....

What's a Global Group?

Denise S wrote:

Can I work in Global Group in Excel?

--

Dave Peterson

Hi, Denise & I have been trying to figure this out together. Is there a way
to switch from one worksheet to another, in the same workbook, and stay in
the same cell from sheet to sheet without having to scroll?

"Dave Peterson" wrote:

Maybe....

What's a Global Group?

Denise S wrote:

Can I work in Global Group in Excel?

--

Dave Peterson

Hi, Denise and I have been trying to figure this out together. Is there a way
to move from one sheet to another sheet and remain in the same cell as in
Lotus? Excel always reverts to cell A1 or the cell where you left off when
previously on that sheet.

Gail

"Dave Peterson" wrote:

Maybe....

What's a Global Group?

Denise S wrote:

Can I work in Global Group in Excel?

--

Dave Peterson

If you want to use a couple of macros, you can do it.

Option Explicit
Dim CurActCellAddr As String
Private Sub Workbook_Open()
CurActCellAddr = ActiveCell.Address
End Sub
Private Sub Workbook_SheetActivate(ByVal Sh As Object)
If CurActCellAddr = "" Then
'do nothing
Else
With Application
.EnableEvents = False
.Goto Sh.Range(CurActCellAddr)
.EnableEvents = True
End With
End If
CurActCellAddr = ActiveCell.Address
End Sub
Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, _
ByVal Target As Range)
CurActCellAddr = ActiveCell.Address
End Sub

rightclick on the excel icon to the left of the File|edit|view (on the worksheet
menubar).
select view code and paste this in.

Then try it out.

The first time the address gets initialized is with the workbook open event. If
you test without closing/reopening your workbook, it may take one selection
change to "prime the pump."




trees1021 wrote:

Hi, Denise and I have been trying to figure this out together. Is there a way
to move from one sheet to another sheet and remain in the same cell as in
Lotus? Excel always reverts to cell A1 or the cell where you left off when
previously on that sheet.

Gail

"Dave Peterson" wrote:

Maybe....

What's a Global Group?

Denise S wrote:

Can I work in Global Group in Excel?

--

Dave Peterson


--

Dave Peterson

Does this help?

Click the first sheet tab, hold down <Ctrl, click in last sheet tab.
Now, navigate to desired cell and click in it.

That cell is now the cell of focus in *all* your sheets.
Right click in a tab and choose "Ungroup Sheets".

When you click in any sheet tab, you'll find that the cell you selected when
the sheets were "Grouped", is now selected in all the sheets.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"trees1021" wrote in message
...
Hi, Denise and I have been trying to figure this out together. Is there a
way
to move from one sheet to another sheet and remain in the same cell as in
Lotus? Excel always reverts to cell A1 or the cell where you left off when
previously on that sheet.

Gail

"Dave Peterson" wrote:

Maybe....

What's a Global Group?

Denise S wrote:

Can I work in Global Group in Excel?

--

Dave Peterson