I'm using one of Ron de Bruin's macros (thanks Ron!) to split a large
worksheet into separate workbooks. Is there anyway to have it automatically
password protect the resulting documents as well? I tried just adding the
password to the main document, but it didn't password protect the resulting
documents.

Thanks!!