Can't hide working sheet

[jomili]

I have a routine that operates on the workbook open event to write the user name and date to Columns A and B on the Sheet1 worksheet, and if I open the workbook to that worksheet everything performs as desired. However, I don't want my users seeing this sheet, so want to open to Sheet2, but write the info to Sheet1. I tried to do that by turning off screen updating and opening to sheet 2, but get a Run-Time error 1004 "Select Method of Range class failed".

My former code for the line in question was:

Please Login or Register  to view this content.

That's been replaced with the non-working line:

Please Login or Register  to view this content.

The full code is posted below.

Please Login or Register  to view this content.

[romperstomper]

You can't select a range on a sheet that isn't the active one, but you don't need to select it anyway:

Please Login or Register  to view this content.

[jomili]

Nice. I like the way you used the With and End With statements for both my problem area and also my clunky area. I really enjoy seeing a more elegant solution than I could think of. Thanks for your help; it works beautifully.