Default Cell

pzamory

Board Regular
Joined
May 2, 2002
Messages
135
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
 

Excel Facts

When they said...
When they said you are going to "Excel at life", they meant you "will be doing Excel your whole life".
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
Code:
Private Sub Workbook_SheetActivate(ByVal Sh As Object)
Range("E1").Select
End Sub
 
Upvote 0
Thanks. Would it matter that I already have Vba code to search through all my workbooks?
 
Upvote 0
I would not think this would cause you any problems.
You keep saying Workbooks but I think you mean Worksheets.
 
Upvote 0

Forum statistics

Threads
1,213,494
Messages
6,113,974
Members
448,537
Latest member
Et_Cetera

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top