Error with protected cells "Excel 2000 SP2"

[Ctech]

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

 

[Jim Rech]

I ran your code in Excel 2000 (SP3, the version I have) on a sheet protected
but with no password. There was no error.

Btw, just providing the runtime error code is useless. There are thousands
of errors that produce the 1004 code. Providing the text of the error
message is much more helpful, but not quite as helpful as code that actually
errors out.


--
Jim
message |
| Hi Guys
|
| i have protected A worksheet, and all cells that can be ammended, have
| I unlocked.
|
| All the macos have "application.activesheet.unprotect("")" etc ... when
| 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 greater
| then 2000 SP2)
|
| Cheers, for all help guys.
|
|
| --
| Ctech
|
|
| ------------------------------------------------------------------------
| Ctech's Profile:
http://www.excelforum.com/member.php?action=getinfo&userid=27745
| View this thread: http://www.excelforum.com/showthread.php?threadid=529540
|