Can't find the information you are looking for here? Then leave a message over on our WinBatch Tech Support Forum.
Keywords: unlocok cells protected worksheet
And how do I find out things like this?
I tried writing a macro, editing it, and translating it, but no joy...
Thanks heaps in Advance!
=============================== This example unlocks cells A1:G37 on Sheet1 so that they can be modified when the sheet is protected. Worksheets("Sheet1").Range("A1:G37").Locked = False Worksheets("Sheet1").Protect ================================so your Winbatch code might look something like:
EASptct = EAS.ProtectContents If EASptct == -1 then EAS.Unprotect ('password') zRange=EAS.Range("b26:b29") zRange.select zRange.locked=@FALSE
Article ID: W14693Filename: Excel unlock some cells in a protected worksheet.txtFile Created: 2000:07:17:11:11:28Last Updated: 2000:07:17:11:11:28