I have a function written designed to write data into a template
(another excel file) -- it'll save me tons of time, but here's the

The excel spreadsheet I'm writing to has locked "AllowEditRange" -- to
which I know the password -- but the sheet itself is locked, and I
don't know the password for that.

I cannot seem to find any way to programmically unlock the range via
the password I'm given -- most ideas I've had have been thwarted
because the cell is locked.

TrevelPosted from http://www.pcreview.co.uk/ newsgroup access