Thread: Date Error
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Murray N Taylor Murray N Taylor is offline
external usenet poster
 
Posts: 1
Default Date Error

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