two identical scripts, one with problem, the other with NO?!

A

active_x

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??
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro Error 1
Complex problem probably easy answer 2
Custom Images not showing in Ribbon toggle button 2
>_< investigating the programing for 'combined cells' >_< 0
Running Batch File from within Excel 5
Can't delete sheets 8
Curious string error in named range automation attempt - just doesn'tseem to make sense! 5
Conditional Problem Or What? 0

Top