Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I use the following macro to jump to a particular worksheet when a
workbook is opened and Sheet1!O70=0, however I'd like to modify it so that when those conditions are met, the cursor will rest on a particular cell such as A1. Are there any suggestions? Thanks in advance. Michael Private Sub Workbook_Open() With Me If .Worksheets("Sheet1").Range("O70").Value = 0 Then .Worksheets("Sheet1").Activate End If End With End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Attempted edit of protected cell jumps user to another cell | Excel Discussion (Misc queries) | |||
Why is Referenced Workbook Saved When ActiveWorkbook is Saved? | Excel Programming | |||
My tab key jumps to the next page, not the adjacent, cell, help... | Excel Discussion (Misc queries) | |||
Create Hyperlink to cell in another Workbook saved in Doc Manageme | Excel Discussion (Misc queries) |