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

I am using

Please Login or Register  to view this content.

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?

I've tested your code and I too get the same problem. But If I use the following, everything works as it should

Please Login or Register  to view this content.

Wouldn't that hide all the Excel books the user has open as well? I only want to hide the one containing the macro.