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
Bookmarks