View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
philc philc is offline
external usenet poster
 
Posts: 1
Default Error Message "Select method of worksheet class failed"

i get the above message whenever a document is opened read only. the
document has the following code

Private Sub Workbook_Open()

Sheets("Homepage").Select

and it fails on the first line. the problem is not present when the
document is opened normally (ie not read only).
there is no protection on any sheets, or any hidden sheets.

Thanks in advance.