Getting "Object variable...not set" on ActiveWorkbook after "Enable Editing"
Posted on 2014-04-07
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?