Office solution: How to select a specific cell when returning to a sheet

Last week, we asked you to help a user reduce her keystrokes just a bit by automating the selection of a specific cell when returning to the sheet. Emilefyon was the first to respond with perhaps the most traditional solution, adding the following sub procedure to the sheet’s module:

Private Sub Worksheet_Activate()

 'Select C3 when returning to the sheet.

 Range("C3").Select

End Sub

It works great and it’s easy enough for most users to implement themselves. Thanks To Rudi-S and Ru7of9 for reminding us about the right-click tab shortcut to the module, which makes the process so much easier for users unaccustomed to adding code!

Thanks to everyone for another great challenge. It was unanimous this time around.