Hi - I'd like to write a macro to protect all the sheets in a workbook (in Excel 97). I don't want to protect the workbook itself, as I have found that that makes WinZip unable to compress the file by more than about 5% (so whenever I send my 5 linked files over email to a client, it would take 28M instead of a mere 8M). I'm just learning VBA and imagined that I might be able to use a method like Worksheets.Protect, but Protect is not valid for the Worksheets object. My next thought is to write a loop that would Protect each sheet... but I haven't quite got to that point of understanding VBA. Is this indeed the way? Can someone suggest code?
Thanks,
Rob
Thanks,
Rob