<div>
I get a syntax error on <br />
<br />
Private Sub Workbook_SheetActivate(ByV<wbr />al Sh As Object)
</div>


I get a syntax error on

Private Sub Workbook_SheetActivate(ByVal Sh As Object)

<div>
Also, I'd like to make sure the workbook ALWAYS opens to sheet 1. I have named the sheets, so in the syntax I am using the name rather than sheet1, sheet2, etc. Is that correct?
</div>


Also, I'd like to make sure the workbook ALWAYS opens to sheet 1. I have named the sheets, so in the syntax I am using the name rather than sheet1, sheet2, etc. Is that correct?

<div>
Yes the CodeName is the name in parenthesis. For example Sheet1(Budget) where 'Budget' is the CodeName. <br />
<br />
Open a new workbook and go to ThisWorkBook -&gt; WorkBook -&gt; Workbook_SheetActivate event in the IDE. Is it different than <b>Private Sub Workbook_SheetActivate(ByV<wbr />al Sh As Object)</b>. If it is you can use CodeName rather than Sh.CodeName in your code.
</div>


Yes the CodeName is the name in parenthesis. For example Sheet1(Budget) where 'Budget' is the CodeName.

Open a new workbook and go to ThisWorkBook -> WorkBook -> Workbook_SheetActivate event in the IDE. Is it different than Private Sub Workbook_SheetActivate(ByVal Sh As Object). If it is you can use CodeName rather than Sh.CodeName in your code.

<div>
<div class="content wysiwyg-content">
I have a workbook that includes about 15 worksheets. I need to block access to individual worksheets using different passwords for each worksheet.
</div>
</div>


I have a workbook that includes about 15 worksheets. I need to block access to individual worksheets using different passwords for each worksheet.

Block access to only one worksheet in a workbook

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.