Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Application On Time
Hi,
I see nothing wrong with it providing it has been called it will set the active cell to 90000000 12:02. Is that what you want it to do? Mike "Varne" wrote: 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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Application On Time
I meant
set the active cell to 9000000000 at 12:02 "Mike H" wrote: Hi, I see nothing wrong with it providing it has been called it will set the active cell to 90000000 12:02. Is that what you want it to do? Mike "Varne" wrote: 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. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Application On Time
It works. Few thoughts
--May be try that once again..Set the Security level to low/medium in (Tools|Macro|Security). Close application and reopen. From workbook launch VBE using short-key Alt+F11. From menu 'Insert' a module and paste the below code. Save. Get back to Workbook. Run macro from Tools|Macro|Run <selected macro() --"12:02:00" is the 24 hour format.. If this post helps click Yes --------------- Jacob Skaria "Varne" wrote: 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. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Application On Time
Hi!
Yeah. It works. Thank You. "Jacob Skaria" wrote: It works. Few thoughts --May be try that once again..Set the Security level to low/medium in (Tools|Macro|Security). Close application and reopen. From workbook launch VBE using short-key Alt+F11. From menu 'Insert' a module and paste the below code. Save. Get back to Workbook. Run macro from Tools|Macro|Run <selected macro() --"12:02:00" is the 24 hour format.. If this post helps click Yes --------------- Jacob Skaria "Varne" wrote: 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. |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Application On Time
Hi!
It works now. Thank You. "Mike H" wrote: I meant set the active cell to 9000000000 at 12:02 "Mike H" wrote: Hi, I see nothing wrong with it providing it has been called it will set the active cell to 90000000 12:02. Is that what you want it to do? Mike "Varne" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Why does MSO application configure each time | Setting up and Configuration of Excel | |||
Login date & time to the VBA application. | Excel Programming | |||
runtime error 75 when I run the application for second time | Excel Programming | |||
Application.Calculation gives run time error | Excel Programming |