LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 126
Default Application On Time

Hi!

Can someone tell me what is wrong with the following 2 macros? I have
limited access to Internet so if I am delayed in responding to responses
please appologise.

Sub Hey()

Application.OnTime TimeValue("12:02:00"), "Hermit"


End Sub


Sub Hermit()

ActiveCell.Value = 9000000

End Sub



The Error message say macros disabled or not available in this workbook. I
have enabled macros and both macros are in the same module in the workbook.

Thanks.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Why does MSO application configure each time debra mckoy Setting up and Configuration of Excel 0 December 4th 09 01:03 PM
Login date & time to the VBA application. [email protected] Excel Programming 2 July 5th 07 03:25 PM
runtime error 75 when I run the application for second time divya Excel Programming 2 July 8th 06 11:58 AM
Application.Calculation gives run time error Martien Janssen Excel Programming 6 October 13th 05 02:33 PM


All times are GMT +1. The time now is 08:45 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"