Protect, Unprotect error

Hi,

I have made a timeheet in excel for around 100 users. I have emailed this
and the majority work just fine. On the sheet is a button with a macro
attached that clears the form for the next weeks use. Very basic macro that
selects cells in which they can enter data and deletes them returning to the
first cell afterwards. This works great.

I have spoken to one usr who receieved a run-time 1004 error because some of
those cells are obviously locked. There is no reason for this as it works on
many other PC's. However, to combat this I thought I would simply add
ActiveSheet.Unprotect to the beggining of the macro and ActiveSheet.Protect
to the end and solve the problem. When I do this however, running the macro
causes Excel to close down.

Please help as the only other way around this is talking him through
selecting all the required cells and making sure they are indeed 'unlocked'
which I would prefer to avoid.

Also, does anyone know why th ecells would have locked for him and no one
else? He is on the same version of Excel 2003.

If they copied from another worksheet to this one, it's possible that they
copied the LOCKED setting. IIRC, the default value is LOCKED = TRUE.
--
HTH,
Barb Reinhardt



"Pyrite" wrote:

> Hi,
>
> I have made a timeheet in excel for around 100 users. I have emailed this
> and the majority work just fine. On the sheet is a button with a macro
> attached that clears the form for the next weeks use. Very basic macro that
> selects cells in which they can enter data and deletes them returning to the
> first cell afterwards. This works great.
>
> I have spoken to one usr who receieved a run-time 1004 error because some of
> those cells are obviously locked. There is no reason for this as it works on
> many other PC's. However, to combat this I thought I would simply add
> ActiveSheet.Unprotect to the beggining of the macro and ActiveSheet.Protect
> to the end and solve the problem. When I do this however, running the macro
> causes Excel to close down.
>
> Please help as the only other way around this is talking him through
> selecting all the required cells and making sure they are indeed 'unlocked'
> which I would prefer to avoid.
>
> Also, does anyone know why th ecells would have locked for him and no one
> else? He is on the same version of Excel 2003.