Tracey,
No this is not possible.
However, you could use Windows Task Manager, or one of the many
third-party scheduling utilities, to run the macro. You would probably
need a command line in the scheduler something like this...
"C:\Program Files\...\Msaccess.exe" "C:\PathToDB\MyDB.mdb" /x NameOfMacro
If you put a Quit action as the final action in the macro, it sort of
amounts to the same thing as not opening the database.