Default Cell

[pzamory]

Good morning.

I have multiple workbooks in my Excel sheet. Is it possible for the default cell on each workbook to be cell E1 instead of A1?

Thanks

 

[My Aswer Is This]

To do that you would need to be willing to use Vba.
Adding this script to your workbook will cause Range("E1") to be selected every time you activate your sheet.

This is an auto sheet event script
Your Workbook must be Macro enabled
To install this code:
Right-click on any sheet tab

Select View Code from the pop-up context menu​

Double click on ThisWorkbook

Paste this code in the VBA edit window

Private Sub Workbook_SheetActivate(ByVal Sh As Object)
Range("E1").Select
End Sub

 

[pzamory]

Thanks. Would it matter that I already have Vba code to search through all my workbooks?

 

[My Aswer Is This]

I would not think this would cause you any problems.
You keep saying Workbooks but I think you mean Worksheets.