![]() |
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?? |
All times are GMT +1. The time now is 02:04 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com