First WorkSheet focus

YarmulnikA · July 20, 2006, 10:11am

I am hiding some worksheets in a file. I need to set focus to the first visible worksheet, because when I open the file after hiding the first worksheet, which has the focus, I get a blank.

Thanks,

Alex.

Laurence · July 20, 2006, 6:29pm

Hi Alex,

Please try to use Worksheets.ActiveSheetIndex property.