I'm hoping someone can shed some light on the following problems i'm having:
I created a spreadsheet in Excel 2002 for Windows that has password protection assigned to the entire sheet as well as another level of password protection on various cells (ie: allow users to edit ranges). It also has a bunch of textboxes with vb code that automatically enters an "X" in the box when the box is clicked on. Works great on the pc.
I now have a couple users with MACS running Excel 10 for MAC trying to use the spreadsheet. Unfortunately, the mac is not asking for a password when they try and edit a cell. It just says that the entire worksheet is protected and that they should Unprotect the sheet. In short, the mac doesn't seem to have the ability to password protect on the cell level. Furthermore, the VB code never runs when the textboxes are double-clicked.
I hope i've managed to make myself clear and hope someone has some answers.
Thank you very much for your time!
Jack.
I created a spreadsheet in Excel 2002 for Windows that has password protection assigned to the entire sheet as well as another level of password protection on various cells (ie: allow users to edit ranges). It also has a bunch of textboxes with vb code that automatically enters an "X" in the box when the box is clicked on. Works great on the pc.
I now have a couple users with MACS running Excel 10 for MAC trying to use the spreadsheet. Unfortunately, the mac is not asking for a password when they try and edit a cell. It just says that the entire worksheet is protected and that they should Unprotect the sheet. In short, the mac doesn't seem to have the ability to password protect on the cell level. Furthermore, the VB code never runs when the textboxes are double-clicked.
I hope i've managed to make myself clear and hope someone has some answers.
Thank you very much for your time!
Jack.