VBA macro application.ontime timevalue error

I have read a few threads that talk about running a macro upon workbook open at a certain time. I get this error

"Cannot run the macro "C:\Doctments and Settings\JBRANUM\Application Data\Microsoft\Excel\XLSTART\personal.xls'!DAILYROLLFORWARD'. The macro may not be available in this workbook or all marcos may be disabled."

Under File - Options - Trust center - Macro Settings - I have "Enable all marcos..." enabled and all of my macros are inside the workbook personal.xls.

In ThisWorkbook module i have this

Please Login or Register  to view this content.

The macro I want to run is also in personal.xls and here it is

Please Login or Register  to view this content.

Any ideas how to fix my error? Thanks to everyone in advance.

DAILYROLLFORWARD as well

Ah. That solved the run problem but I have a new one now pertaining to the macro itself. Do I need to start a new thread?

In this code it errors at Set DtRNG = Sheets("Sheet1").Range("A:A").SpecialCells(xlConstants) and says no cells were found. I presume possibly because I have a formula in cell a1 instead of data directly. Is that correct?

Please Login or Register  to view this content.

Solved. Thanks.