On 24 Apr 2005 03:05:07 -0700, "Sam" <samuel.berthelot@voila.fr>
wrote:

>Hi;
>I'd like to prevent the user to edit the content of my cells in the
>sheet. This is easy, however I want these same cells to be editable
>progamatically by my macros. And this is my problem, if I lock the
>cell, how can i modify them in the macros ?

Unprotect the sheet by VBA code before you edit it:

Sub EditProtectedSheet()

If Sheet1.ProtectContents Then
Sheet1.Unprotect "MyPassword"
End If

Sheet1.Cells(1, 3).Value = "Input2"

Sheet1.Protect "MyPassword"

End Sub



---------------------------------------------------------
Hank Scorpio
scorpionet who hates spam is at iprimus.com.au (You know what to do.)
* Please keep all replies in this Newsgroup. Thanks! *