<div>
objExcel.sheets(1).Protect<wbr /> DrawingObjects:=True, Contents:=True, Scenarios:=True<br />
<br />
?<br />

</div>


objExcel.sheets(1).Protect DrawingObjects:=True, Contents:=True, Scenarios:=True

?


<div>
thanks<br />
<br />
but i cannot set the password to protect<br />
<br />
Could you tell me how to do that?
</div>


thanks

but i cannot set the password to protect

Could you tell me how to do that?

<div>
<div class="content wysiwyg-content">
how to protect excel work sheet with visual basic?<br />
<br />
the macro code of protection is:<br />
&nbsp; &nbsp; ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True<br />
<br />
how to transform it to visual basic code?<br />
<br />
PS: I open excel with the following code:<br />
<br />
&nbsp; &nbsp; Set objExcel = GetObject(Source)<br />
&nbsp; &nbsp; objExcel.Application.Visib<wbr />le = True<br />
&nbsp; &nbsp; objExcel.windows(1).Visibl<wbr />e = True<br />
&nbsp; &nbsp; objExcel.sheets(1).cells(1<wbr />, 1).Value = &quot;hihi&quot;<br />
<br />
........ after that I want to protect the workbook<br />
<br />
<br />
<br />
Thanks
</div>
</div>


how to protect excel work sheet with visual basic?

the macro code of protection is:
    ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True

how to transform it to visual basic code?

PS: I open excel with the following code:

    Set objExcel = GetObject(Source)
    objExcel.Application.Visible = True
    objExcel.windows(1).Visible = True
    objExcel.sheets(1).cells(1, 1).Value = "hihi"

........ after that I want to protect the workbook



Thanks

vb code to protect excel worksheet

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.