I have a problem. I have a workbook that is a overtime equalization project that I have been working on. It has departments in several worksheets that have macros that sort the employees by the lowest overtime hours.
In order to make the macro work, I had to include in the macro a command to unprotect the active worksheet otherwise, I got an error because there is some pasting that goes on in the macor also. Before the macro is finished, I have a protect active sheet command so the data is protect. Things like names, social sec. number, date of hire. I have a specific group of cells that remain unprotected because they are unlocked for data entry.
So anyway, my problem occured when I set the workbook up to be shared.
Now I am getting a Run time error '1004'. It states: unprotect method of worksheet class failed.
The first command in the macro is AcitveSheet.Unprotect.
Is this the problem?
Please help.
Thanks,
Jerry
In order to make the macro work, I had to include in the macro a command to unprotect the active worksheet otherwise, I got an error because there is some pasting that goes on in the macor also. Before the macro is finished, I have a protect active sheet command so the data is protect. Things like names, social sec. number, date of hire. I have a specific group of cells that remain unprotected because they are unlocked for data entry.
So anyway, my problem occured when I set the workbook up to be shared.
Now I am getting a Run time error '1004'. It states: unprotect method of worksheet class failed.
The first command in the macro is AcitveSheet.Unprotect.
Is this the problem?
Please help.
Thanks,
Jerry