| 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 | |||
![active_x[_8_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
