ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   two identical scripts, one with problem, the other with NO?! (https://www.excelbanter.com/excel-programming/281534-two-identical-scripts-one-problem-other-no.html)

active_x[_8_]

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