Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
two identical scripts, one with problem, the other with NO?!
Example: (refer to help40.zip)
http://www.geocities.com/remember_it/help40.zip There are two files contained in help40.zip, help40a.xls and help40b.xls . Both excel files have the following codes: ------------------------------------------------------------------------------- Workbook_Open() lock_ws .... Names("size").RefersToRange.Locked = False 'problem arises here .... ------------------------------------------------------------------------------- For the code: Names("###").RefersToRange.Locked = False Why does it go wrong in help40a.xls but NOT in help40b.xls? How to correct that script in help40a.xls?? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
delete scripts | Excel Worksheet Functions | |||
Forumlas or scripts? | Excel Discussion (Misc queries) | |||
SQL Scripts in Excel | Excel Discussion (Misc queries) | |||
insurance calulater scripts | Excel Discussion (Misc queries) | |||
VBA code scripts in macro | Excel Programming |