Hey,
Please help me the following situation.
1 I created survey in 2003 version with password protection to change ( it will forbid people to change anything except some cells in the sheets). Not password protection for workbook (TOOLS/OPTIONS/Password to open)
2 But when people send back those surveys, some of them will covert that into 2007 versions (.XLSX)
3 So I open those 2007 version surveys (.XLSX), every time password prompt will appear before I can view anything. (actually I could give any password. The system will accept it)
4 I created macro to disabled that
Workbooks.Open Filename:=xxx, UpdateLinks:=0, password:="0"
It does not work. Please let me know if it is clear. I really appreciate it.
Please help me the following situation.
1 I created survey in 2003 version with password protection to change ( it will forbid people to change anything except some cells in the sheets). Not password protection for workbook (TOOLS/OPTIONS/Password to open)
2 But when people send back those surveys, some of them will covert that into 2007 versions (.XLSX)
3 So I open those 2007 version surveys (.XLSX), every time password prompt will appear before I can view anything. (actually I could give any password. The system will accept it)
4 I created macro to disabled that
Workbooks.Open Filename:=xxx, UpdateLinks:=0, password:="0"
It does not work. Please let me know if it is clear. I really appreciate it.
