Excel sheet protected

[henpat]

Hello all
I have a space in my sheet1 that is blocked but I need work in this space
with a VBA macro.
How can I work in this blocked space by keeping (after macro) the cells
blocked?

Thanks
henpat

 

[Dave Peterson]

You could have your macro unprotect the worksheet, do its work and then
reprotect the worksheet.

With worksheets("sheet99")
.unprotect password:="hi"
'do your work
.protect password:="hi"
end with

 

[henpat]

Thanks a lot

You could have your macro unprotect the worksheet, do its work and then
reprotect the worksheet.

With worksheets("sheet99")
.unprotect password:="hi"
'do your work
.protect password:="hi"
end with