Protection sheet

  • Thread starter Thread starter henpat
  • Start date Start date
H

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
 
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.
 
Thanks very much
henpat
K Dales said:
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.
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Run Macro If Cell have "x" value 0
Excel [VBA] Check from a cell into another sheet and bring back result in MsgBox 0
VBA set thick borders around non empty cells in range 0
Call a function when a cell changes 1
Excel sheet protected 2
Call a function in some sheets 1
Run two macros for two different sheets 11
Macro to Combine Data from Multiple Sheets with Cell References 4

Back
Top