Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
select only last 30 days of a work sheet | Excel Worksheet Functions | |||
extracting totals from 1 work sheet to another work work sheet | Excel Discussion (Misc queries) | |||
Populating work sheet combox with another work sheet values | Excel Discussion (Misc queries) | |||
LeftFooterPicture instruction does not appear to work | Excel Programming | |||
Find instruction fails (from foreign sheet) | Excel Programming |