| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Error with protected cells "Excel 2000 SP2"
Hi Guys i have protected A worksheet, and all cells that can be ammended, hav I unlocked. All the macos have "application.activesheet.unprotect("")" etc ... whe they run... however I get the "Runtime Error 1004" when I run it... If I take of all protection, then the form and macros run perfectly.. Anyone know what the problem can be? (PS!! The form works fine protected and unprotected in versions greate then 2000 SP2) Cheers, for all help guys -- Ctec ----------------------------------------------------------------------- Ctech's Profile: http://www.excelforum.com/member.php...fo&userid=2774 View this thread: http://www.excelforum.com/showthread.php?threadid=52954 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
| "Locked for Editing" error on a non-protected file | Excel Discussion (Misc queries) | |||
| Excel will not "show all" from an Advanced Filter on a sheet with protected cells. | Excel Programming | |||
| "Object Required" Error in Excel 2000 but Not in Excel 97 (!?) | Excel Programming | |||
| "Member Not Found" Error with Excel 2000 | Excel Programming | |||
![Ctech[_134_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
