Loop through all worksheets in workbook to perform action fix code

I have tried both of the codes below to Loop through each worksheet in my workbook and select cells.

I know it seems as though that is trivial, but as many people use the file, and the function of the file is to create a quick request, starting at the input cell is crucial.

That being said, the codes below are only running on the currently viewed worksheet, it's not actually looping through to perform the task. I have tried two versions based on research, and I cannot get either to perform task on each worksheet, please point out the error I am missing so I can get this up and running. Thanks in advance.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

I get an error message.

Runtime error 1004
Select method of Range class failed.

That is exactly the solution I needed. It worked like a charm.

Just as a background, each user of this workbook enters a file number in cell I3 and it pulls all pertinent information from a second file, then the user changes anything that needs updated, prints and emails a PDF of the file to the proper person. All of this is achieved with a macro. often times we change other parts of the sheet to fit a specific customer requirements, but I need the I3 cell to be selected on all sheets every time we open the workbook so that the user isn't starting at a different place of the sheet each time. It is to be a time saver, and for lack of better reason/term, needs to be idiot proof. If I tell a user to open workbook and enter file number in I3 and for the first 20 times it's the cell already selected, then on the 21st time we have had problems explaining to a novice user that they have to manually select the cell, since almost all of it is auto populated.

The reason for the Macro is to have minimal training needed to begin using the workbook. Thank you for your help again.