Hiding workbook during macro running makes Excel unable to access it behind the scenes

I am using

Set curworkbook = ActiveWorkbook

curworkbook.Windows(1).Visible = False

once my userform loads to hide the workbook, however doing so makes all the references to the worksheets within fail to work.


Is there a way to hide Excel (ONLY the macrobook, other books the user has open should stay open) completely and still allow the macro to successfully reference it?