thanks for the replies, everyone.

1. sheets are protected, but get unprotected before getting written.
2. shtemp exists.

this application works on my computer and on another one my office, bu
it doesn't work on the client's computer.

dave, you may be onto something. i talked to the client yesterday, an
found out he's using win2k. i coded this application in excel 2003, bu
he is probably using an older version

--
dream
-----------------------------------------------------------------------
dreamz's Profile: http://www.excelforum.com/member.php...fo&userid=2646
View this thread: http://www.excelforum.com/showthread.php?threadid=50792