Always open workbook to default sheet and cell

Hello again -

Is there a code that will allow me to always open one workbook to a default sheet and have C4 automatically be the starting point?

Thank you for the help.

Try this code and report back if it works:

Please Login or Register  to view this content.

EDIT: Enter the sheet name that you want to select between the " " in the code (where it currently says "Sheet2")

Hi, Penny.

Copy this code into the ThisWorkbook module:

Please Login or Register  to view this content.

HTH

Jason

Thank you all! It works like a charm.