Does anyone know how to get Excel to allow VBA code to write to a
password protected worksheet?

I am using a work-around solution at the moment whereby the VBA
unprotects the relevant worksheet, writes data to it, then re-protects
it.

There must be a better way than this though. Obviously I don't want my
users to delete the formulas etc in the worksheet but I want my code to
be able to write data to the worksheet without having to
unprotect/re-protect it all the time!

Thanks
-Rob


--
TheRobsterUK


------------------------------------------------------------------------
TheRobsterUK's Profile: http://www.excelforum.com/member.php...fo&userid=9924
View this thread: http://www.excelforum.com/showthread...hreadid=374547