-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
runwhen
-
R
VBA to Close and Save Workbook on Timer
Hello, I found code in this forum to close my workbook after a certain amount of time, but when I use it, after closing the workbook, it wants to re-open it. Can anyone provide code that works or help me fix this one? Public RunWhen As Double Public Const cRunIntervalSeconds = 300 ' this is...- richardtims
- Thread
- const crunintervalseconds public runwhen workbook
- Replies: 3
- Forum: Excel Questions
-
K
Script Out of range error
Dear All, I want a particular cell to blink until the value set to today's date. following is the code used. Option Explicit Public RunWhen As Double Sub StartBlink() With Worksheets("Summary") .EnableOutlining = True .Protect Password:="isuzu", _ Contents:=True, UserInterfaceOnly:=True End...- Krishnab4u
- Thread
- end error runwhen script out of range error startblink
- Replies: 3
- Forum: Excel Questions
-
K
code modification
Hi all, I took this code from another spreadsheet and need it simplified. I was able to get the cell to change color, but not blink. I am wondering if it is because the code refers to indexes. Anyway, my code would be much more simple. Here is the data. 1 is good 5 is bad. So the code would...- Kim B
- Thread
- code end runwhen startblink text
- Replies: 0
- Forum: Excel Questions
-
Application.OnTime Error
Hi there, I have a macro which I'm using to toggle an auto-save. The Sub 'Auto_Save_Record' works fine and turns on the auto-save every minute, but my toggle only works to turn the Auto_Save_Record on. When I toggle Auto_Save_Record to OFF, I get the Error 1004: Method 'OnTime' of object...- RobbieC
- Thread
- application.ontime auto-save auto_save_record projectdatadirectory runwhen
- Replies: 4
- Forum: Excel Questions
