Selecting a particular cell for all worksheets

[ttaysg]

Dear all, my first time posting here.

I have a workbook containing about 50 different sheets. I use macros to lock and unlock all the sheets. All the sheets are protected, and I want the users of the sheets to have a particular cell selected for them. Just wondering why I'm getting a 1004 error everytime I insert this piece of code in.

Problematic Code:
For Each s In ActiveWorkbook.Worksheets
s.cells(5,2).select
Next

Temporary band-aid solution:
For Each s In ActiveWorkbook.Worksheets
s.Activate
ActiveSheet.Cells(5, 2).Select
Next

What am I getting wrong? Thanks in advance for answering

[TMS]

You can't select a cell if a sheet isn't active. Try Application.GoTo

[YasserKhalil]

Try this

Please Login or Register  to view this content.

[ttaysg]

Thanks all, appreciate it. added reps!

[TMS]

You're welcome. Thanks for the rep.