View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
JorgeLMV JorgeLMV is offline
external usenet poster
 
Posts: 3
Default select instruction is not able to work with a sheet

Hi

I'm using second time this site, I'm not sure how it's working, from first
post I still don't get any comment.

This issue is when a excel file is opened, we have an instruction like
sheet("Setup").select inside workbook_open event, and in some excels this
works fine, when it does'nt work a message "error 57121 defined by the
object" comes.

Reading a Microsoft information, I changed the instruction creating first an
object for the especific sheet and then using the same select instruction, it
works fine but still I don't know this is the right way.

Thanks in advance for your comments

--
Regards
Jorge Mendoza V