Protection sheet

[henpat]

Hello all
When I runs my VBA macro there is an error because it works in a cell
bloqued.
How can I use the macros in this cell boqued?

Thanks a lot
henpat

[K Dales]

At the start of your macro code put this:
Worksheets("SheetName").Unprotect

At the end, turn protection back on
Worksheets("SheetName").Protect

Use the actual sheet name, of course.
--
- K Dales


"henpat" wrote:

> Hello all
> When I runs my VBA macro there is an error because it works in a cell
> bloqued.
> How can I use the macros in this cell boqued?
>
> Thanks a lot
> henpat
>
>
>

[henpat]

Thanks very much
henpat
"K Dales" <KDales@discussions.microsoft.com> wrote in message
news:17D896DC-56B4-4673-8D67-1A366AE93DE6@microsoft.com...
> At the start of your macro code put this:
> Worksheets("SheetName").Unprotect
>
> At the end, turn protection back on
> Worksheets("SheetName").Protect
>
> Use the actual sheet name, of course.
> --
> - K Dales
>
>
> "henpat" wrote:
>
>> Hello all
>> When I runs my VBA macro there is an error because it works in a cell
>> bloqued.
>> How can I use the macros in this cell boqued?
>>
>> Thanks a lot
>> henpat
>>
>>
>>