<div>
what line of code triggers the error?
</div>


<div>
ActiveWorkbook..Unprotect Password = strMyPassword<br />
<br />
I unprotect the workbook first in case it is still protected, so I can hide tabs that may or may not be hidden. <br />
strMyPassword is Dim'd as: Global Const strMyPassword as string = ...
</div>


ActiveWorkbook..Unprotect Password = strMyPassword

I unprotect the workbook first in case it is still protected, so I can hide tabs that may or may not be hidden.
strMyPassword is Dim'd as: Global Const strMyPassword as string = ...

<div>
Ok, thanks, that explains it. As it turns out, I'm lucky; this thing will live on SharePoint, and it doesn't have this problem opening up from there.<br />
<br />
Thanks again
</div>


Ok, thanks, that explains it. As it turns out, I'm lucky; this thing will live on SharePoint, and it doesn't have this problem opening up from there.

Thanks again

<div>
<div class="content wysiwyg-content">
Hello - in the Workbook_Open event, I do some initialization things like protecting the workbook, protect the individual worksheets, and hide some columns on a data input worksheet.<br />
<br />
I was ready to roll this out, but when I changed the workbook file name, the first time opening it, everything stopped until I answered the prompt about &quot;Enable Editing&quot;. After I click that button, then I get the Object variable... not set&quot;. <br />
<br />
Shouldn't ActiveWorkbook always be set?<br />
<br />
Thanks
</div>
</div>


Hello - in the Workbook_Open event, I do some initialization things like protecting the workbook, protect the individual worksheets, and hide some columns on a data input worksheet.

I was ready to roll this out, but when I changed the workbook file name, the first time opening it, everything stopped until I answered the prompt about "Enable Editing". After I click that button, then I get the Object variable... not set". 

Shouldn't ActiveWorkbook always be set?

Thanks

Getting &quot;Object variable...not set&quot; on ActiveWorkbook after  &quot;Enable Editing&quot;

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

Getting &quot;Object variable...not set&quot; on ActiveWorkbook after &quot;Enable Editing&quot;

Getting "Object variable...not set" on ActiveWorkbook after "Enable Editing"