run-time error 1004

  • Thread starter Thread starter anair
  • Start date Start date
A

anair

i have a workbook with macros and some vba scripts and
have password protected some of the sheets. i have created
this workbook in Excel 2002.

I distributed it to users using Excel 2000, who are
getting Run Time Error 1004, the file is protected and
will be read-only.

The sheets are protected but i have opened ranges for data
entry. All works well for users with Excel 2000.

What I have tried without success:
- Save File As | Tools | General Options | Advanced |
Encryption Type - Weak or Office 97/2000 compatible.

it still gives the run-time error. anyone has seen this?
 
Ooh. I think you had a typo in your post and it was an important one.

all works ok for users of xl2k or xl2002?

If it works ok in xl2k, but not xl2002, then it might be that xl2002 is a little
more stringent with protection. Somethings that were ok in xl2k are no long
ok. (setting the userinterfaceonly to true needs the password in xl2002.)

If it works ok in xl2002, but not in xl2k, then maybe you depended on a feature
that is only available with xl2002. (xl2002 allows a finer granularity of
protection of ranges than xl2k does.)

You may want to unprotect your code and try it on a pc (or version of excel)
that gets the error. Post back with the offending code marked nicely--please no
workbooks.
 
Back
Top