Workbook_Open, run macro after cell is selected

[Formula11]

With respect to the event "Workbook_Open", I wanted to call up a macro called Input, which has a relationship with the active cell.
The problem is that Workbook_Open may be too early to pick up the active cell.
Is there an event which triggers after the workbook is opened and a cell is selected?

Private Sub Workbook_Open()
    Application.Run "Input"
End Sub

Private Sub Input()
    If ActiveCell.Characters(1, 1).Font.Name Like "Arial" Then
        'Some input here
    End If
End Sub

 

[Yongle]

Is the cell always the SAME cell ?
- use workbook_open to activate the correct sheet and select the cell

Should the user asked to select the cell ? You could use something like this

Private Sub Workbook_Open()
    Dim Cel As Range
    Sheets("Sheet1").Activate
    Set Cel = Application.InputBox("Select a cell...", "Input", , , , , , 8)
    Cel.Select
    Application.Run "Input"
End Sub

 

[Formula11]

Thanks for responding.
The cell would be that last selected before closing the workbook.
I was hoping not to introduce a new step.
Possibly using one from the list below? Maybe it's not possible.

Activate
AddinInstall
AddinUninstall
AfterRemoteChange
AfterSave
AfterXmlExport
AfterXmlImport
BeforeClose
BeforePrint
BeforeRemoteChange
BeforeSave
BeforeXmlExport
BeforeXmlImport
Deactivate
ModelChange
NewChart
NewSheet
Open
PivotTableCloseConnection
PivotTableOpenConnection
RowsetComplete
SheetActivate
SheetBeforeDelete
SheetBeforeDoubleClick
SheetBeforeRightClick
SheetCalculate
SheetChange
SheetDeactivate
SheetFollowHyperlink
SheetLensGalleryRenderComplete
SheetPivotTableAfterValueChange
SheetPivotTableBeforeAllocateChanges
SheetPivotTableBeforeCommitChanges
SheetPivotTableBeforeDiscardChanges
SheetPivotTableChangeSync
SheetPivotTableUpdate
SheetSelectionChange
SheetTableUpdate
Sync
WindowActivate
WindowDeactivate
WindowResize

 

[Yongle]

You are in danger of over-thinking this

Test what happens when you save and reopen a workbook
- save it with a different active cell each time

Which cell is active when the workbook re-opens ?
- it is always the cell that was active when the workbook was saved and closed

So ...
... unless there is something else happening to change normal Excel behaviour ...
...... the cell last selected before closing the workbook
......... is the active cell when the workbook opens

 

[Formula11]

Yes but this is not captured in Workbook_Open.

 

[Yongle]

Create a new workbook, add the code below in ThisWorkbook module, and save and close with a different active cell a few times
It ALWAYS reports the cell that was active when the workbook was closed

Private Sub Workbook_Open()
MsgBox ActiveCell.Address
End Sub

 

[Formula11]

Yes you are right.
Apologies for the inconvenience then.
I don't know why it works now and not then.

 

[Yongle]

I don't know why it works now and not then.

That is one of the many "features" of VBA that are so endearing