View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
K Dales[_2_] K Dales[_2_] is offline
external usenet poster
 
Posts: 1,163
Default Protection sheet

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