If I protect the worksheet with a macro, do you I have to unprotect it while
writing, right?

"Earl Kiosterud" wrote in message
...
Fernando,

Protect the workbook in a macro, like this:

Sheets(MySheet).Protect UserInterfaceOnly:=True ' Password:="MyPass" '
Password optional.

Or your macro can unprotect the sheet, make its changes, then protect it.
--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"Fernando Duran" wrote in message
. ..
I'm trying to write in a worksheet using a macro, I have no problem, as
long
the worksheet isn't protect. But I want to protect the file, so, the
user
wont be able to change anything.. can I get some help in this problem?