J
jitusohan
I have Excel document that can be downloaded from Internet. Once the
document is downloaded users can fill in data. The document has some
VBA Macros (Password protected) which allows users to input data to
only a particular range.
Steps:
1. User downloads the document on Mac
2. Opens and adds the data
3. Saves and quits the excel
4. Now again user opens the saved document and adds data and tries to
save. User gets an error "document not saved"
I have tried doing saveas, tried saving to a diff location and many
other options that I read on newsgroup but I am still getting error.
But there is an interesting thing that happens, if I don't have the
document as password protected. Just open and close the VBA module and
then try saving, the document saves properly. I can't understand why
it happens. This is not a choice for end users and the document is
password protected and users don't have the password.
I would really appreciate if any one could help.
Thanks.
document is downloaded users can fill in data. The document has some
VBA Macros (Password protected) which allows users to input data to
only a particular range.
Steps:
1. User downloads the document on Mac
2. Opens and adds the data
3. Saves and quits the excel
4. Now again user opens the saved document and adds data and tries to
save. User gets an error "document not saved"
I have tried doing saveas, tried saving to a diff location and many
other options that I read on newsgroup but I am still getting error.
But there is an interesting thing that happens, if I don't have the
document as password protected. Just open and close the VBA module and
then try saving, the document saves properly. I can't understand why
it happens. This is not a choice for end users and the document is
password protected and users don't have the password.
I would really appreciate if any one could help.
Thanks.