how to allow macro to write on a protected sheet

without using unprotect/protect way..
is there a way to allow program to write in certain ranges while users can't
write.

Thanks for all the help you provided.
MVM

Hi MVM,

If the UserInterfaceOnly argument is used with the protect method, tthe
worksheet can be manipulated with code.

The setting is not persistent between Excel sessions, so it is common
practice to set protection in the workbook open event.


---
Regards,
Norman



"MVM" <[email protected]> wrote in message
news:[email protected]...
> without using unprotect/protect way..
> is there a way to allow program to write in certain ranges while users
> can't
> write.
>
> Thanks for all the help you provided.
> MVM