this is often a misleading error which occurs when a
reference is missing. stop any code , then under
Tools/references chech if anything is missing. If there
is. then you'll need to re-point to the dll or ocx or
whatever.

Patrick Molloy
Microsoft Excel MVP
-----Original Message-----
having a bad hair day with a VBA call, I use the code

tmpdate = Date

this is run as part of an Auto_Open() proc in a
module "Main" in a workbook, the code is protected.

This works fine on some systems, but one others I get an
error message:

Cannot create object in hidden module Main

I know I have been and cured this before but I cannot
for
the life of me remember how it's done.

Murray

.