View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
active_x[_8_] active_x[_8_] is offline
external usenet poster
 
Posts: 4
Default 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??