Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 22
Default Blinking Text

OK, i know its kind of frowned on, but I need to have a cell that
flashes text.

How do i do that in Office 2007?

Any help appreciated
TIA
Esra
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 434
Default Blinking Text

hi, Esra !

OK, i know its kind of frowned on, but I need to have a cell that flashes text.
How do i do that in Office 2007?


see: http://www.cpearson.com/excel/BlinkingText.aspx

or... there is a wise-tricky procedure (posted by KL in spanish ng sometime ago)...
(and with minor changes based on Thomas Jansen -1999- post)...
that let's you to preserve the undo-levels, and you might want to give it a try...

if any doudbts (or further information)... would you please comment ?
hth,
hector.

assuming 'a cell' es [B1] and you need it to 'flash' if it's value is greater than 5

1) select [B1]... - [menu] format / conditional format...
formula: - =(b15)*(mod(second(now()),2)=0)
format: - apply formats as needed/wished/...

2) copy/paste the following code-lines:
===
a) in a general code module:
===
Option Private Module
Public Sequence As Date
Sub StartBlinking()
Sequence = Now + TimeSerial(0, 0, 1)
Worksheets(1).Range("b1").Calculate ' modify/adapt/... worksheet's index/name as appropriate
Application.OnTime Sequence, "StartBlinking"
End Sub
Sub StopBlinking()
On Error Resume Next
Application.OnTime Sequence, "StartBlinking", Schedule:=False
End Sub
===
b) in 'ThisWorkbook' code module:
===
Private Sub Workbook_Open()
StartBlinking
End Sub
Private Sub Workbook_BeforeClose(Cancel As Boolean)
StopBlinking
End Sub


  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 22
Default Blinking Text

On Sat, 2 Feb 2008 02:09:24 -0600, "Héctor Miguel"
wrote:

hi, Esra !

OK, i know its kind of frowned on, but I need to have a cell that flashes text.
How do i do that in Office 2007?


see: http://www.cpearson.com/excel/BlinkingText.aspx

or... there is a wise-tricky procedure (posted by KL in spanish ng sometime ago)...
(and with minor changes based on Thomas Jansen -1999- post)...
that let's you to preserve the undo-levels, and you might want to give it a try...

if any doudbts (or further information)... would you please comment ?
hth,
hector.

assuming 'a cell' es [B1] and you need it to 'flash' if it's value is greater than 5

1) select [B1]... - [menu] format / conditional format...
formula: - =(b15)*(mod(second(now()),2)=0)
format: - apply formats as needed/wished/...

2) copy/paste the following code-lines:
===
a) in a general code module:
===
Option Private Module
Public Sequence As Date
Sub StartBlinking()
Sequence = Now + TimeSerial(0, 0, 1)
Worksheets(1).Range("b1").Calculate ' modify/adapt/... worksheet's index/name as appropriate
Application.OnTime Sequence, "StartBlinking"
End Sub
Sub StopBlinking()
On Error Resume Next
Application.OnTime Sequence, "StartBlinking", Schedule:=False
End Sub
===
b) in 'ThisWorkbook' code module:
===
Private Sub Workbook_Open()
StartBlinking
End Sub
Private Sub Workbook_BeforeClose(Cancel As Boolean)
StopBlinking
End Sub



No that doesnt seem to work for me.

When I open or close the workbook with the private subs in there, it
says compiling error, sub or function not defined

Same thing when i close the workbook


When i use conditional formatting, it says "You cannot use relative
references in Conditional Formatting criteria for colour scales, data
bars and icon sets."

Am I doing something wrong?

ty

Esra
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 22,906
Default Blinking Text

Hector's code works fine for me.

You may have mis-read his directions or when copying code left something out.

Note: B1 won't blink the color on/off unless there is data in the cell,
although the blinking code is running. Even a <space will start it blinking.


Gord Dibben MS Excel MVP

On Sat, 02 Feb 2008 23:23:39 +1300, Esra Dekan wrote:

On Sat, 2 Feb 2008 02:09:24 -0600, "Héctor Miguel"
wrote:

hi, Esra !

OK, i know its kind of frowned on, but I need to have a cell that flashes text.
How do i do that in Office 2007?


see: http://www.cpearson.com/excel/BlinkingText.aspx

or... there is a wise-tricky procedure (posted by KL in spanish ng sometime ago)...
(and with minor changes based on Thomas Jansen -1999- post)...
that let's you to preserve the undo-levels, and you might want to give it a try...

if any doudbts (or further information)... would you please comment ?
hth,
hector.

assuming 'a cell' es [B1] and you need it to 'flash' if it's value is greater than 5

1) select [B1]... - [menu] format / conditional format...
formula: - =(b15)*(mod(second(now()),2)=0)
format: - apply formats as needed/wished/...

2) copy/paste the following code-lines:
===
a) in a general code module:
===
Option Private Module
Public Sequence As Date
Sub StartBlinking()
Sequence = Now + TimeSerial(0, 0, 1)
Worksheets(1).Range("b1").Calculate ' modify/adapt/... worksheet's index/name as appropriate
Application.OnTime Sequence, "StartBlinking"
End Sub
Sub StopBlinking()
On Error Resume Next
Application.OnTime Sequence, "StartBlinking", Schedule:=False
End Sub
===
b) in 'ThisWorkbook' code module:
===
Private Sub Workbook_Open()
StartBlinking
End Sub
Private Sub Workbook_BeforeClose(Cancel As Boolean)
StopBlinking
End Sub



No that doesnt seem to work for me.

When I open or close the workbook with the private subs in there, it
says compiling error, sub or function not defined

Same thing when i close the workbook


When i use conditional formatting, it says "You cannot use relative
references in Conditional Formatting criteria for colour scales, data
bars and icon sets."

Am I doing something wrong?

ty

Esra


  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 22
Default Blinking Text

I have huh?

I open the file after i have installed the VBA as per instructions,
(copied and pasted) and when i open it, it tells me

"Compile error. Sub or function not defined"

Also says the same when I close it after clicking off that message.

I copied and pasted the formula as provided, so I dont see how that
can be wrong.

Not sure what is going on here??, :((

Need help please.

TIA
Esra






On Sat, 02 Feb 2008 12:11:37 -0800, Gord Dibben <gorddibbATshawDOTca
wrote:

Hector's code works fine for me.

You may have mis-read his directions or when copying code left something out.

Note: B1 won't blink the color on/off unless there is data in the cell,
although the blinking code is running. Even a <space will start it blinking.


Gord Dibben MS Excel MVP

On Sat, 02 Feb 2008 23:23:39 +1300, Esra Dekan wrote:

On Sat, 2 Feb 2008 02:09:24 -0600, "Héctor Miguel"
wrote:

hi, Esra !

OK, i know its kind of frowned on, but I need to have a cell that flashes text.
How do i do that in Office 2007?

see: http://www.cpearson.com/excel/BlinkingText.aspx

or... there is a wise-tricky procedure (posted by KL in spanish ng sometime ago)...
(and with minor changes based on Thomas Jansen -1999- post)...
that let's you to preserve the undo-levels, and you might want to give it a try...

if any doudbts (or further information)... would you please comment ?
hth,
hector.

assuming 'a cell' es [B1] and you need it to 'flash' if it's value is greater than 5

1) select [B1]... - [menu] format / conditional format...
formula: - =(b15)*(mod(second(now()),2)=0)
format: - apply formats as needed/wished/...

2) copy/paste the following code-lines:
===
a) in a general code module:
===
Option Private Module
Public Sequence As Date
Sub StartBlinking()
Sequence = Now + TimeSerial(0, 0, 1)
Worksheets(1).Range("b1").Calculate ' modify/adapt/... worksheet's index/name as appropriate
Application.OnTime Sequence, "StartBlinking"
End Sub
Sub StopBlinking()
On Error Resume Next
Application.OnTime Sequence, "StartBlinking", Schedule:=False
End Sub
===
b) in 'ThisWorkbook' code module:
===
Private Sub Workbook_Open()
StartBlinking
End Sub
Private Sub Workbook_BeforeClose(Cancel As Boolean)
StopBlinking
End Sub



No that doesnt seem to work for me.

When I open or close the workbook with the private subs in there, it
says compiling error, sub or function not defined

Same thing when i close the workbook


When i use conditional formatting, it says "You cannot use relative
references in Conditional Formatting criteria for colour scales, data
bars and icon sets."

Am I doing something wrong?

ty

Esra



  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 35,218
Default Blinking Text

Maybe you got hit by linewrap in the newsgroup post.

Sub StartBlinking()
Sequence = Now + TimeSerial(0, 0, 1)
' modify/adapt/... worksheet's index/name as appropriate
Worksheets(1).Range("b1").Calculate
Application.OnTime Sequence, "StartBlinking"
End Sub

That "appropriate" line is the end of the comment. It's not really part of the
code.

Esra Dekan wrote:

I have huh?

I open the file after i have installed the VBA as per instructions,
(copied and pasted) and when i open it, it tells me

"Compile error. Sub or function not defined"

Also says the same when I close it after clicking off that message.

I copied and pasted the formula as provided, so I dont see how that
can be wrong.

Not sure what is going on here??, :((

Need help please.

TIA
Esra

On Sat, 02 Feb 2008 12:11:37 -0800, Gord Dibben <gorddibbATshawDOTca
wrote:

Hector's code works fine for me.

You may have mis-read his directions or when copying code left something out.

Note: B1 won't blink the color on/off unless there is data in the cell,
although the blinking code is running. Even a <space will start it blinking.


Gord Dibben MS Excel MVP

On Sat, 02 Feb 2008 23:23:39 +1300, Esra Dekan wrote:

On Sat, 2 Feb 2008 02:09:24 -0600, "Héctor Miguel"
wrote:

hi, Esra !

OK, i know its kind of frowned on, but I need to have a cell that flashes text.
How do i do that in Office 2007?

see: http://www.cpearson.com/excel/BlinkingText.aspx

or... there is a wise-tricky procedure (posted by KL in spanish ng sometime ago)...
(and with minor changes based on Thomas Jansen -1999- post)...
that let's you to preserve the undo-levels, and you might want to give it a try...

if any doudbts (or further information)... would you please comment ?
hth,
hector.

assuming 'a cell' es [B1] and you need it to 'flash' if it's value is greater than 5

1) select [B1]... - [menu] format / conditional format...
formula: - =(b15)*(mod(second(now()),2)=0)
format: - apply formats as needed/wished/...

2) copy/paste the following code-lines:
===
a) in a general code module:
===
Option Private Module
Public Sequence As Date
Sub StartBlinking()
Sequence = Now + TimeSerial(0, 0, 1)
Worksheets(1).Range("b1").Calculate ' modify/adapt/... worksheet's index/name as appropriate
Application.OnTime Sequence, "StartBlinking"
End Sub
Sub StopBlinking()
On Error Resume Next
Application.OnTime Sequence, "StartBlinking", Schedule:=False
End Sub
===
b) in 'ThisWorkbook' code module:
===
Private Sub Workbook_Open()
StartBlinking
End Sub
Private Sub Workbook_BeforeClose(Cancel As Boolean)
StopBlinking
End Sub



No that doesnt seem to work for me.

When I open or close the workbook with the private subs in there, it
says compiling error, sub or function not defined

Same thing when i close the workbook


When i use conditional formatting, it says "You cannot use relative
references in Conditional Formatting criteria for colour scales, data
bars and icon sets."

Am I doing something wrong?

ty

Esra


--

Dave Peterson
  #7   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 22
Default Blinking Text

Maybe by chance, could someone email me a workbook with a flashing
cell? and I should be able to work it out from there.

I just cant seem to get it for some reason.

My email address is in the message i think, minus the underscore.

I wouls appreciate it

Esra



On Sat, 02 Feb 2008 20:14:12 -0600, Dave Peterson
wrote:

Maybe you got hit by linewrap in the newsgroup post.

Sub StartBlinking()
Sequence = Now + TimeSerial(0, 0, 1)
' modify/adapt/... worksheet's index/name as appropriate
Worksheets(1).Range("b1").Calculate
Application.OnTime Sequence, "StartBlinking"
End Sub

That "appropriate" line is the end of the comment. It's not really part of the
code.

Esra Dekan wrote:

I have huh?

I open the file after i have installed the VBA as per instructions,
(copied and pasted) and when i open it, it tells me

"Compile error. Sub or function not defined"

Also says the same when I close it after clicking off that message.

I copied and pasted the formula as provided, so I dont see how that
can be wrong.

Not sure what is going on here??, :((

Need help please.

TIA
Esra

On Sat, 02 Feb 2008 12:11:37 -0800, Gord Dibben <gorddibbATshawDOTca
wrote:

Hector's code works fine for me.

You may have mis-read his directions or when copying code left something out.

Note: B1 won't blink the color on/off unless there is data in the cell,
although the blinking code is running. Even a <space will start it blinking.


Gord Dibben MS Excel MVP

On Sat, 02 Feb 2008 23:23:39 +1300, Esra Dekan wrote:

On Sat, 2 Feb 2008 02:09:24 -0600, "Héctor Miguel"
wrote:

hi, Esra !

OK, i know its kind of frowned on, but I need to have a cell that flashes text.
How do i do that in Office 2007?

see: http://www.cpearson.com/excel/BlinkingText.aspx

or... there is a wise-tricky procedure (posted by KL in spanish ng sometime ago)...
(and with minor changes based on Thomas Jansen -1999- post)...
that let's you to preserve the undo-levels, and you might want to give it a try...

if any doudbts (or further information)... would you please comment ?
hth,
hector.

assuming 'a cell' es [B1] and you need it to 'flash' if it's value is greater than 5

1) select [B1]... - [menu] format / conditional format...
formula: - =(b15)*(mod(second(now()),2)=0)
format: - apply formats as needed/wished/...

2) copy/paste the following code-lines:
===
a) in a general code module:
===
Option Private Module
Public Sequence As Date
Sub StartBlinking()
Sequence = Now + TimeSerial(0, 0, 1)
Worksheets(1).Range("b1").Calculate ' modify/adapt/... worksheet's index/name as appropriate
Application.OnTime Sequence, "StartBlinking"
End Sub
Sub StopBlinking()
On Error Resume Next
Application.OnTime Sequence, "StartBlinking", Schedule:=False
End Sub
===
b) in 'ThisWorkbook' code module:
===
Private Sub Workbook_Open()
StartBlinking
End Sub
Private Sub Workbook_BeforeClose(Cancel As Boolean)
StopBlinking
End Sub



No that doesnt seem to work for me.

When I open or close the workbook with the private subs in there, it
says compiling error, sub or function not defined

Same thing when i close the workbook


When i use conditional formatting, it says "You cannot use relative
references in Conditional Formatting criteria for colour scales, data
bars and icon sets."

Am I doing something wrong?

ty

Esra

  #8   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 22,906
Default Blinking Text

What you refer to as "formula" is either a macro or event code.

As Dave points out, you could have been hit by line wrap.

My reader did not wrap but yours may have.

Here is a cleaned up set with a revision. I used a sheetname. You will edit
that to your sheetname

a) Copy these two macros to a general code module:
=================

Option Private Module
Public Sequence As Date
Sub StartBlinking()
Sequence = Now + TimeSerial(0, 0, 1)
Worksheets("MySheet").Range("B1").Calculate
Application.OnTime Sequence, "StartBlinking"
End Sub

Sub StopBlinking()
On Error Resume Next
Application.OnTime Sequence, "StartBlinking", Schedule:=False
End Sub

===================

b) Copy these two events to 'ThisWorkbook' code module:
===================

Private Sub Workbook_Open()
StartBlinking
End Sub

Private Sub Workbook_BeforeClose(Cancel As Boolean)
StopBlinking
End Sub

======================


Gord

On Sun, 03 Feb 2008 12:52:19 +1300, Esra Dekan wrote:

I copied and pasted the formula as provided, so I dont see how that
can be wrong.


  #9   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 22,906
Default Blinking Text

Have sent one to you.


Gord

On Sun, 03 Feb 2008 16:18:45 +1300, Esra Dekan wrote:

Maybe by chance, could someone email me a workbook with a flashing
cell? and I should be able to work it out from there.

I just cant seem to get it for some reason.

My email address is in the message i think, minus the underscore.

I wouls appreciate it

Esra


  #10   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 22
Default Blinking Text

That doesnt work here either.

maybe something wrong with the program? Do I need an add=in or
something?


Esra


On Sat, 02 Feb 2008 20:10:42 -0800, Gord Dibben <gorddibbATshawDOTca
wrote:

Have sent one to you.


Gord

On Sun, 03 Feb 2008 16:18:45 +1300, Esra Dekan wrote:

Maybe by chance, could someone email me a workbook with a flashing
cell? and I should be able to work it out from there.

I just cant seem to get it for some reason.

My email address is in the message i think, minus the underscore.

I wouls appreciate it

Esra



  #11   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 22,906
Default Blinking Text

Worked fine before I sent it to you.

Did you get a message about enabling macros when you opened the workbook I sent?

If not, your macro security is set too high and Excel automatically prevents
code from running and puts the workbook in the HelpAbout MS ExcelDisabled
Items.

Have a look there first and re-enable it then reset your security level.

ToolsOptionsSecurityMacro Security.

Set it to "Medium", OK out, then close out Excel and re-open.

Enable macros when you get the message about workbook contains macros.


Gord

On Mon, 04 Feb 2008 07:38:58 +1300, Esra Dekan wrote:

That doesnt work here either.

maybe something wrong with the program? Do I need an add=in or
something?


Esra


On Sat, 02 Feb 2008 20:10:42 -0800, Gord Dibben <gorddibbATshawDOTca
wrote:

Have sent one to you.


Gord

On Sun, 03 Feb 2008 16:18:45 +1300, Esra Dekan wrote:

Maybe by chance, could someone email me a workbook with a flashing
cell? and I should be able to work it out from there.

I just cant seem to get it for some reason.

My email address is in the message i think, minus the underscore.

I wouls appreciate it

Esra


  #12   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 22
Default Blinking Text

Still not working,

When I open the file, it comes up saying "Compile Error. Sub or
Function Not Defined"

and goes to this macro

Private Sub Workbook_Open()
StartBlinking
End Sub

When closing does the same too, goes to the macro StopBlinking


Any help??

Esra




On Sun, 03 Feb 2008 11:46:17 -0800, Gord Dibben <gorddibbATshawDOTca
wrote:

Worked fine before I sent it to you.

Did you get a message about enabling macros when you opened the workbook I sent?

If not, your macro security is set too high and Excel automatically prevents
code from running and puts the workbook in the HelpAbout MS ExcelDisabled
Items.

Have a look there first and re-enable it then reset your security level.

ToolsOptionsSecurityMacro Security.

Set it to "Medium", OK out, then close out Excel and re-open.

Enable macros when you get the message about workbook contains macros.


Gord

On Mon, 04 Feb 2008 07:38:58 +1300, Esra Dekan wrote:

That doesnt work here either.

maybe something wrong with the program? Do I need an add=in or
something?


Esra


On Sat, 02 Feb 2008 20:10:42 -0800, Gord Dibben <gorddibbATshawDOTca
wrote:

Have sent one to you.


Gord

On Sun, 03 Feb 2008 16:18:45 +1300, Esra Dekan wrote:

Maybe by chance, could someone email me a workbook with a flashing
cell? and I should be able to work it out from there.

I just cant seem to get it for some reason.

My email address is in the message i think, minus the underscore.

I wouls appreciate it

Esra

  #13   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 35,218
Default Blinking Text

Did you put the StartBlinking and StopBlinking subroutines into a General module
in that same workbook's project?

Esra Dekan wrote:

Still not working,

When I open the file, it comes up saying "Compile Error. Sub or
Function Not Defined"

and goes to this macro

Private Sub Workbook_Open()
StartBlinking
End Sub

When closing does the same too, goes to the macro StopBlinking

Any help??

Esra

On Sun, 03 Feb 2008 11:46:17 -0800, Gord Dibben <gorddibbATshawDOTca
wrote:

Worked fine before I sent it to you.

Did you get a message about enabling macros when you opened the workbook I sent?

If not, your macro security is set too high and Excel automatically prevents
code from running and puts the workbook in the HelpAbout MS ExcelDisabled
Items.

Have a look there first and re-enable it then reset your security level.

ToolsOptionsSecurityMacro Security.

Set it to "Medium", OK out, then close out Excel and re-open.

Enable macros when you get the message about workbook contains macros.


Gord

On Mon, 04 Feb 2008 07:38:58 +1300, Esra Dekan wrote:

That doesnt work here either.

maybe something wrong with the program? Do I need an add=in or
something?


Esra


On Sat, 02 Feb 2008 20:10:42 -0800, Gord Dibben <gorddibbATshawDOTca
wrote:

Have sent one to you.


Gord

On Sun, 03 Feb 2008 16:18:45 +1300, Esra Dekan wrote:

Maybe by chance, could someone email me a workbook with a flashing
cell? and I should be able to work it out from there.

I just cant seem to get it for some reason.

My email address is in the message i think, minus the underscore.

I wouls appreciate it

Esra


--

Dave Peterson
  #14   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 22,906
Default Blinking Text

Does this occur in the workbook I sent you?

If so, have you changed anything at all?

Was working fine when I emailed the workbook to you.

"asdfg" in B1 was blinking a green color.

I still have the original if you want it re-sent.


Gord Dibben MS Excel MVP

On Thu, 07 Feb 2008 19:26:44 +1300, Esra Dekan wrote:

Still not working,

When I open the file, it comes up saying "Compile Error. Sub or
Function Not Defined"

and goes to this macro

Private Sub Workbook_Open()
StartBlinking
End Sub

When closing does the same too, goes to the macro StopBlinking


Any help??

Esra




On Sun, 03 Feb 2008 11:46:17 -0800, Gord Dibben <gorddibbATshawDOTca
wrote:

Worked fine before I sent it to you.

Did you get a message about enabling macros when you opened the workbook I sent?

If not, your macro security is set too high and Excel automatically prevents
code from running and puts the workbook in the HelpAbout MS ExcelDisabled
Items.

Have a look there first and re-enable it then reset your security level.

ToolsOptionsSecurityMacro Security.

Set it to "Medium", OK out, then close out Excel and re-open.

Enable macros when you get the message about workbook contains macros.


Gord

On Mon, 04 Feb 2008 07:38:58 +1300, Esra Dekan wrote:

That doesnt work here either.

maybe something wrong with the program? Do I need an add=in or
something?


Esra


On Sat, 02 Feb 2008 20:10:42 -0800, Gord Dibben <gorddibbATshawDOTca
wrote:

Have sent one to you.


Gord

On Sun, 03 Feb 2008 16:18:45 +1300, Esra Dekan wrote:

Maybe by chance, could someone email me a workbook with a flashing
cell? and I should be able to work it out from there.

I just cant seem to get it for some reason.

My email address is in the message i think, minus the underscore.

I wouls appreciate it

Esra


  #15   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 22
Default Blinking Text

Yes, happens in the workbook you sent, and cell b1 is just green with
text in, not blinking.

All i get in MY workbook here, is the compile error thing. I dont
know enough to know what that even means.

The Private sub thing, I right clicked "this Workbook",,,and inserted
a module, pasted the Private Sub into there.

It must be something with my excelt surely, coz it happens on the book
you sent me,,,maybe?

:((

TIA

Esra



On Thu, 07 Feb 2008 10:06:54 -0800, Gord Dibben <gorddibbATshawDOTca
wrote:

Does this occur in the workbook I sent you?

If so, have you changed anything at all?

Was working fine when I emailed the workbook to you.

"asdfg" in B1 was blinking a green color.

I still have the original if you want it re-sent.


Gord Dibben MS Excel MVP

On Thu, 07 Feb 2008 19:26:44 +1300, Esra Dekan wrote:

Still not working,

When I open the file, it comes up saying "Compile Error. Sub or
Function Not Defined"

and goes to this macro

Private Sub Workbook_Open()
StartBlinking
End Sub

When closing does the same too, goes to the macro StopBlinking


Any help??

Esra




On Sun, 03 Feb 2008 11:46:17 -0800, Gord Dibben <gorddibbATshawDOTca
wrote:

Worked fine before I sent it to you.

Did you get a message about enabling macros when you opened the workbook I sent?

If not, your macro security is set too high and Excel automatically prevents
code from running and puts the workbook in the HelpAbout MS ExcelDisabled
Items.

Have a look there first and re-enable it then reset your security level.

ToolsOptionsSecurityMacro Security.

Set it to "Medium", OK out, then close out Excel and re-open.

Enable macros when you get the message about workbook contains macros.


Gord

On Mon, 04 Feb 2008 07:38:58 +1300, Esra Dekan wrote:

That doesnt work here either.

maybe something wrong with the program? Do I need an add=in or
something?


Esra


On Sat, 02 Feb 2008 20:10:42 -0800, Gord Dibben <gorddibbATshawDOTca
wrote:

Have sent one to you.


Gord

On Sun, 03 Feb 2008 16:18:45 +1300, Esra Dekan wrote:

Maybe by chance, could someone email me a workbook with a flashing
cell? and I should be able to work it out from there.

I just cant seem to get it for some reason.

My email address is in the message i think, minus the underscore.

I wouls appreciate it

Esra



  #16   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 35,218
Default Blinking Text

Rightclick on ThisWorkbook and choose View code.

Don't insert a module.

Esra Dekan wrote:

Yes, happens in the workbook you sent, and cell b1 is just green with
text in, not blinking.

All i get in MY workbook here, is the compile error thing. I dont
know enough to know what that even means.

The Private sub thing, I right clicked "this Workbook",,,and inserted
a module, pasted the Private Sub into there.

It must be something with my excelt surely, coz it happens on the book
you sent me,,,maybe?

:((

TIA

Esra

On Thu, 07 Feb 2008 10:06:54 -0800, Gord Dibben <gorddibbATshawDOTca
wrote:

Does this occur in the workbook I sent you?

If so, have you changed anything at all?

Was working fine when I emailed the workbook to you.

"asdfg" in B1 was blinking a green color.

I still have the original if you want it re-sent.


Gord Dibben MS Excel MVP

On Thu, 07 Feb 2008 19:26:44 +1300, Esra Dekan wrote:

Still not working,

When I open the file, it comes up saying "Compile Error. Sub or
Function Not Defined"

and goes to this macro

Private Sub Workbook_Open()
StartBlinking
End Sub

When closing does the same too, goes to the macro StopBlinking


Any help??

Esra




On Sun, 03 Feb 2008 11:46:17 -0800, Gord Dibben <gorddibbATshawDOTca
wrote:

Worked fine before I sent it to you.

Did you get a message about enabling macros when you opened the workbook I sent?

If not, your macro security is set too high and Excel automatically prevents
code from running and puts the workbook in the HelpAbout MS ExcelDisabled
Items.

Have a look there first and re-enable it then reset your security level.

ToolsOptionsSecurityMacro Security.

Set it to "Medium", OK out, then close out Excel and re-open.

Enable macros when you get the message about workbook contains macros.


Gord

On Mon, 04 Feb 2008 07:38:58 +1300, Esra Dekan wrote:

That doesnt work here either.

maybe something wrong with the program? Do I need an add=in or
something?


Esra


On Sat, 02 Feb 2008 20:10:42 -0800, Gord Dibben <gorddibbATshawDOTca
wrote:

Have sent one to you.


Gord

On Sun, 03 Feb 2008 16:18:45 +1300, Esra Dekan wrote:

Maybe by chance, could someone email me a workbook with a flashing
cell? and I should be able to work it out from there.

I just cant seem to get it for some reason.

My email address is in the message i think, minus the underscore.

I wouls appreciate it

Esra


--

Dave Peterson
  #17   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 22
Default Blinking Text

That doesnt work either.

Going to give up I think.

Thanks
Esra



On Thu, 07 Feb 2008 20:25:29 -0600, Dave Peterson
wrote:

Rightclick on ThisWorkbook and choose View code.

Don't insert a module.

Esra Dekan wrote:

Yes, happens in the workbook you sent, and cell b1 is just green with
text in, not blinking.

All i get in MY workbook here, is the compile error thing. I dont
know enough to know what that even means.

The Private sub thing, I right clicked "this Workbook",,,and inserted
a module, pasted the Private Sub into there.

It must be something with my excelt surely, coz it happens on the book
you sent me,,,maybe?

:((

TIA

Esra

On Thu, 07 Feb 2008 10:06:54 -0800, Gord Dibben <gorddibbATshawDOTca
wrote:

Does this occur in the workbook I sent you?

If so, have you changed anything at all?

Was working fine when I emailed the workbook to you.

"asdfg" in B1 was blinking a green color.

I still have the original if you want it re-sent.


Gord Dibben MS Excel MVP

On Thu, 07 Feb 2008 19:26:44 +1300, Esra Dekan wrote:

Still not working,

When I open the file, it comes up saying "Compile Error. Sub or
Function Not Defined"

and goes to this macro

Private Sub Workbook_Open()
StartBlinking
End Sub

When closing does the same too, goes to the macro StopBlinking


Any help??

Esra




On Sun, 03 Feb 2008 11:46:17 -0800, Gord Dibben <gorddibbATshawDOTca
wrote:

Worked fine before I sent it to you.

Did you get a message about enabling macros when you opened the workbook I sent?

If not, your macro security is set too high and Excel automatically prevents
code from running and puts the workbook in the HelpAbout MS ExcelDisabled
Items.

Have a look there first and re-enable it then reset your security level.

ToolsOptionsSecurityMacro Security.

Set it to "Medium", OK out, then close out Excel and re-open.

Enable macros when you get the message about workbook contains macros.


Gord

On Mon, 04 Feb 2008 07:38:58 +1300, Esra Dekan wrote:

That doesnt work here either.

maybe something wrong with the program? Do I need an add=in or
something?


Esra


On Sat, 02 Feb 2008 20:10:42 -0800, Gord Dibben <gorddibbATshawDOTca
wrote:

Have sent one to you.


Gord

On Sun, 03 Feb 2008 16:18:45 +1300, Esra Dekan wrote:

Maybe by chance, could someone email me a workbook with a flashing
cell? and I should be able to work it out from there.

I just cant seem to get it for some reason.

My email address is in the message i think, minus the underscore.

I wouls appreciate it

Esra

  #18   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 22,906
Default Blinking Text

Other than send you another working copy of a workbook, I see nothing else to
help you.

Well........maybe try opening the Immediate Window from VBE and copy this in and
hit ENTER

Application.EnableEvents = True


Gord

On Fri, 08 Feb 2008 15:01:24 +1300, Esra Dekan wrote:

Yes, happens in the workbook you sent, and cell b1 is just green with
text in, not blinking.

All i get in MY workbook here, is the compile error thing. I dont
know enough to know what that even means.

The Private sub thing, I right clicked "this Workbook",,,and inserted
a module, pasted the Private Sub into there.

It must be something with my excelt surely, coz it happens on the book
you sent me,,,maybe?

:((

TIA

Esra



On Thu, 07 Feb 2008 10:06:54 -0800, Gord Dibben <gorddibbATshawDOTca
wrote:

Does this occur in the workbook I sent you?

If so, have you changed anything at all?

Was working fine when I emailed the workbook to you.

"asdfg" in B1 was blinking a green color.

I still have the original if you want it re-sent.


Gord Dibben MS Excel MVP

On Thu, 07 Feb 2008 19:26:44 +1300, Esra Dekan wrote:

Still not working,

When I open the file, it comes up saying "Compile Error. Sub or
Function Not Defined"

and goes to this macro

Private Sub Workbook_Open()
StartBlinking
End Sub

When closing does the same too, goes to the macro StopBlinking


Any help??

Esra




On Sun, 03 Feb 2008 11:46:17 -0800, Gord Dibben <gorddibbATshawDOTca
wrote:

Worked fine before I sent it to you.

Did you get a message about enabling macros when you opened the workbook I sent?

If not, your macro security is set too high and Excel automatically prevents
code from running and puts the workbook in the HelpAbout MS ExcelDisabled
Items.

Have a look there first and re-enable it then reset your security level.

ToolsOptionsSecurityMacro Security.

Set it to "Medium", OK out, then close out Excel and re-open.

Enable macros when you get the message about workbook contains macros.


Gord

On Mon, 04 Feb 2008 07:38:58 +1300, Esra Dekan wrote:

That doesnt work here either.

maybe something wrong with the program? Do I need an add=in or
something?


Esra


On Sat, 02 Feb 2008 20:10:42 -0800, Gord Dibben <gorddibbATshawDOTca
wrote:

Have sent one to you.


Gord

On Sun, 03 Feb 2008 16:18:45 +1300, Esra Dekan wrote:

Maybe by chance, could someone email me a workbook with a flashing
cell? and I should be able to work it out from there.

I just cant seem to get it for some reason.

My email address is in the message i think, minus the underscore.

I wouls appreciate it

Esra


  #19   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 22
Default Blinking Text

Now I am even more confused. Im so dumb when it comes to a lot of
things in Excel.

Where is the "immediate" window in VBE?


Esra



On Thu, 07 Feb 2008 20:37:39 -0800, Gord Dibben <gorddibbATshawDOTca
wrote:

Other than send you another working copy of a workbook, I see nothing else to
help you.

Well........maybe try opening the Immediate Window from VBE and copy this in and
hit ENTER

Application.EnableEvents = True


Gord

On Fri, 08 Feb 2008 15:01:24 +1300, Esra Dekan wrote:

Yes, happens in the workbook you sent, and cell b1 is just green with
text in, not blinking.

All i get in MY workbook here, is the compile error thing. I dont
know enough to know what that even means.

The Private sub thing, I right clicked "this Workbook",,,and inserted
a module, pasted the Private Sub into there.

It must be something with my excelt surely, coz it happens on the book
you sent me,,,maybe?

:((

TIA

Esra



On Thu, 07 Feb 2008 10:06:54 -0800, Gord Dibben <gorddibbATshawDOTca
wrote:

Does this occur in the workbook I sent you?

If so, have you changed anything at all?

Was working fine when I emailed the workbook to you.

"asdfg" in B1 was blinking a green color.

I still have the original if you want it re-sent.


Gord Dibben MS Excel MVP

On Thu, 07 Feb 2008 19:26:44 +1300, Esra Dekan wrote:

Still not working,

When I open the file, it comes up saying "Compile Error. Sub or
Function Not Defined"

and goes to this macro

Private Sub Workbook_Open()
StartBlinking
End Sub

When closing does the same too, goes to the macro StopBlinking


Any help??

Esra




On Sun, 03 Feb 2008 11:46:17 -0800, Gord Dibben <gorddibbATshawDOTca
wrote:

Worked fine before I sent it to you.

Did you get a message about enabling macros when you opened the workbook I sent?

If not, your macro security is set too high and Excel automatically prevents
code from running and puts the workbook in the HelpAbout MS ExcelDisabled
Items.

Have a look there first and re-enable it then reset your security level.

ToolsOptionsSecurityMacro Security.

Set it to "Medium", OK out, then close out Excel and re-open.

Enable macros when you get the message about workbook contains macros.


Gord

On Mon, 04 Feb 2008 07:38:58 +1300, Esra Dekan wrote:

That doesnt work here either.

maybe something wrong with the program? Do I need an add=in or
something?


Esra


On Sat, 02 Feb 2008 20:10:42 -0800, Gord Dibben <gorddibbATshawDOTca
wrote:

Have sent one to you.


Gord

On Sun, 03 Feb 2008 16:18:45 +1300, Esra Dekan wrote:

Maybe by chance, could someone email me a workbook with a flashing
cell? and I should be able to work it out from there.

I just cant seem to get it for some reason.

My email address is in the message i think, minus the underscore.

I wouls appreciate it

Esra

  #20   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 35,218
Default Blinking Text

Open the VBE and hit ctrl-g (or view|Immediate window)

Esra Dekan wrote:

Now I am even more confused. Im so dumb when it comes to a lot of
things in Excel.

Where is the "immediate" window in VBE?

Esra

On Thu, 07 Feb 2008 20:37:39 -0800, Gord Dibben <gorddibbATshawDOTca
wrote:

Other than send you another working copy of a workbook, I see nothing else to
help you.

Well........maybe try opening the Immediate Window from VBE and copy this in and
hit ENTER

Application.EnableEvents = True


Gord

On Fri, 08 Feb 2008 15:01:24 +1300, Esra Dekan wrote:

Yes, happens in the workbook you sent, and cell b1 is just green with
text in, not blinking.

All i get in MY workbook here, is the compile error thing. I dont
know enough to know what that even means.

The Private sub thing, I right clicked "this Workbook",,,and inserted
a module, pasted the Private Sub into there.

It must be something with my excelt surely, coz it happens on the book
you sent me,,,maybe?

:((

TIA

Esra



On Thu, 07 Feb 2008 10:06:54 -0800, Gord Dibben <gorddibbATshawDOTca
wrote:

Does this occur in the workbook I sent you?

If so, have you changed anything at all?

Was working fine when I emailed the workbook to you.

"asdfg" in B1 was blinking a green color.

I still have the original if you want it re-sent.


Gord Dibben MS Excel MVP

On Thu, 07 Feb 2008 19:26:44 +1300, Esra Dekan wrote:

Still not working,

When I open the file, it comes up saying "Compile Error. Sub or
Function Not Defined"

and goes to this macro

Private Sub Workbook_Open()
StartBlinking
End Sub

When closing does the same too, goes to the macro StopBlinking


Any help??

Esra




On Sun, 03 Feb 2008 11:46:17 -0800, Gord Dibben <gorddibbATshawDOTca
wrote:

Worked fine before I sent it to you.

Did you get a message about enabling macros when you opened the workbook I sent?

If not, your macro security is set too high and Excel automatically prevents
code from running and puts the workbook in the HelpAbout MS ExcelDisabled
Items.

Have a look there first and re-enable it then reset your security level.

ToolsOptionsSecurityMacro Security.

Set it to "Medium", OK out, then close out Excel and re-open.

Enable macros when you get the message about workbook contains macros.


Gord

On Mon, 04 Feb 2008 07:38:58 +1300, Esra Dekan wrote:

That doesnt work here either.

maybe something wrong with the program? Do I need an add=in or
something?


Esra


On Sat, 02 Feb 2008 20:10:42 -0800, Gord Dibben <gorddibbATshawDOTca
wrote:

Have sent one to you.


Gord

On Sun, 03 Feb 2008 16:18:45 +1300, Esra Dekan wrote:

Maybe by chance, could someone email me a workbook with a flashing
cell? and I should be able to work it out from there.

I just cant seem to get it for some reason.

My email address is in the message i think, minus the underscore.

I wouls appreciate it

Esra


--

Dave Peterson


  #21   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 22
Default Blinking Text

Well, that doesnt work either.

I put it in there, then saved it, opened it up again, and it opened
the VBA with this error:


Compile Error:

Sub or Function not defined

Referring to this:

Private Sub Workbook_Open()
StartBlinking
End Sub

When I click off that error message, I check to see if the "immediate"
still contains that command, and although I saved it, it does not.

So, I put it back in, save again, and close the VBA and then save and
close the file, and get this message:

Compile Error:

Sub or Function not defined

Referring to this:

Private Sub Workbook_BeforeClose(Cancel As Boolean)
StopBlinking
End Sub



So, got me stumped.
I just wont have the text blinking. It would of been nice, but not
going to all this trouble for that effect.

TY for all your help everyone.

Esra





On Thu, 14 Feb 2008 15:59:00 -0600, Dave Peterson
wrote:

Open the VBE and hit ctrl-g (or view|Immediate window)

Esra Dekan wrote:

Now I am even more confused. Im so dumb when it comes to a lot of
things in Excel.

Where is the "immediate" window in VBE?

Esra

On Thu, 07 Feb 2008 20:37:39 -0800, Gord Dibben <gorddibbATshawDOTca
wrote:

Other than send you another working copy of a workbook, I see nothing else to
help you.

Well........maybe try opening the Immediate Window from VBE and copy this in and
hit ENTER

Application.EnableEvents = True


Gord

On Fri, 08 Feb 2008 15:01:24 +1300, Esra Dekan wrote:

Yes, happens in the workbook you sent, and cell b1 is just green with
text in, not blinking.

All i get in MY workbook here, is the compile error thing. I dont
know enough to know what that even means.

The Private sub thing, I right clicked "this Workbook",,,and inserted
a module, pasted the Private Sub into there.

It must be something with my excelt surely, coz it happens on the book
you sent me,,,maybe?

:((

TIA

Esra



On Thu, 07 Feb 2008 10:06:54 -0800, Gord Dibben <gorddibbATshawDOTca
wrote:

Does this occur in the workbook I sent you?

If so, have you changed anything at all?

Was working fine when I emailed the workbook to you.

"asdfg" in B1 was blinking a green color.

I still have the original if you want it re-sent.


Gord Dibben MS Excel MVP

On Thu, 07 Feb 2008 19:26:44 +1300, Esra Dekan wrote:

Still not working,

When I open the file, it comes up saying "Compile Error. Sub or
Function Not Defined"

and goes to this macro

Private Sub Workbook_Open()
StartBlinking
End Sub

When closing does the same too, goes to the macro StopBlinking


Any help??

Esra




On Sun, 03 Feb 2008 11:46:17 -0800, Gord Dibben <gorddibbATshawDOTca
wrote:

Worked fine before I sent it to you.

Did you get a message about enabling macros when you opened the workbook I sent?

If not, your macro security is set too high and Excel automatically prevents
code from running and puts the workbook in the HelpAbout MS ExcelDisabled
Items.

Have a look there first and re-enable it then reset your security level.

ToolsOptionsSecurityMacro Security.

Set it to "Medium", OK out, then close out Excel and re-open.

Enable macros when you get the message about workbook contains macros.


Gord

On Mon, 04 Feb 2008 07:38:58 +1300, Esra Dekan wrote:

That doesnt work here either.

maybe something wrong with the program? Do I need an add=in or
something?


Esra


On Sat, 02 Feb 2008 20:10:42 -0800, Gord Dibben <gorddibbATshawDOTca
wrote:

Have sent one to you.


Gord

On Sun, 03 Feb 2008 16:18:45 +1300, Esra Dekan wrote:

Maybe by chance, could someone email me a workbook with a flashing
cell? and I should be able to work it out from there.

I just cant seem to get it for some reason.

My email address is in the message i think, minus the underscore.

I wouls appreciate it

Esra

  #22   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 35,218
Default Blinking Text

It's time to post your macros.

What's Under the ThisWorkbook module?

What's under each (and every) general module?

Esra Dekan wrote:

Well, that doesnt work either.

I put it in there, then saved it, opened it up again, and it opened
the VBA with this error:

Compile Error:

Sub or Function not defined

Referring to this:

Private Sub Workbook_Open()
StartBlinking
End Sub

When I click off that error message, I check to see if the "immediate"
still contains that command, and although I saved it, it does not.

So, I put it back in, save again, and close the VBA and then save and
close the file, and get this message:

Compile Error:

Sub or Function not defined

Referring to this:

Private Sub Workbook_BeforeClose(Cancel As Boolean)
StopBlinking
End Sub

So, got me stumped.
I just wont have the text blinking. It would of been nice, but not
going to all this trouble for that effect.

TY for all your help everyone.

Esra

On Thu, 14 Feb 2008 15:59:00 -0600, Dave Peterson
wrote:

Open the VBE and hit ctrl-g (or view|Immediate window)

Esra Dekan wrote:

Now I am even more confused. Im so dumb when it comes to a lot of
things in Excel.

Where is the "immediate" window in VBE?

Esra

On Thu, 07 Feb 2008 20:37:39 -0800, Gord Dibben <gorddibbATshawDOTca
wrote:

Other than send you another working copy of a workbook, I see nothing else to
help you.

Well........maybe try opening the Immediate Window from VBE and copy this in and
hit ENTER

Application.EnableEvents = True


Gord

On Fri, 08 Feb 2008 15:01:24 +1300, Esra Dekan wrote:

Yes, happens in the workbook you sent, and cell b1 is just green with
text in, not blinking.

All i get in MY workbook here, is the compile error thing. I dont
know enough to know what that even means.

The Private sub thing, I right clicked "this Workbook",,,and inserted
a module, pasted the Private Sub into there.

It must be something with my excelt surely, coz it happens on the book
you sent me,,,maybe?

:((

TIA

Esra



On Thu, 07 Feb 2008 10:06:54 -0800, Gord Dibben <gorddibbATshawDOTca
wrote:

Does this occur in the workbook I sent you?

If so, have you changed anything at all?

Was working fine when I emailed the workbook to you.

"asdfg" in B1 was blinking a green color.

I still have the original if you want it re-sent.


Gord Dibben MS Excel MVP

On Thu, 07 Feb 2008 19:26:44 +1300, Esra Dekan wrote:

Still not working,

When I open the file, it comes up saying "Compile Error. Sub or
Function Not Defined"

and goes to this macro

Private Sub Workbook_Open()
StartBlinking
End Sub

When closing does the same too, goes to the macro StopBlinking


Any help??

Esra




On Sun, 03 Feb 2008 11:46:17 -0800, Gord Dibben <gorddibbATshawDOTca
wrote:

Worked fine before I sent it to you.

Did you get a message about enabling macros when you opened the workbook I sent?

If not, your macro security is set too high and Excel automatically prevents
code from running and puts the workbook in the HelpAbout MS ExcelDisabled
Items.

Have a look there first and re-enable it then reset your security level.

ToolsOptionsSecurityMacro Security.

Set it to "Medium", OK out, then close out Excel and re-open.

Enable macros when you get the message about workbook contains macros.


Gord

On Mon, 04 Feb 2008 07:38:58 +1300, Esra Dekan wrote:

That doesnt work here either.

maybe something wrong with the program? Do I need an add=in or
something?


Esra


On Sat, 02 Feb 2008 20:10:42 -0800, Gord Dibben <gorddibbATshawDOTca
wrote:

Have sent one to you.


Gord

On Sun, 03 Feb 2008 16:18:45 +1300, Esra Dekan wrote:

Maybe by chance, could someone email me a workbook with a flashing
cell? and I should be able to work it out from there.

I just cant seem to get it for some reason.

My email address is in the message i think, minus the underscore.

I wouls appreciate it

Esra


--

Dave Peterson
  #23   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 22
Default Blinking Text

Under ThisWorkbook

Private Sub Workbook_Open()
StartBlinking
End Sub

Private Sub Workbook_BeforeClose(Cancel As Boolean)
StopBlinking
End Sub


Under Sheet1 "General"

Sub StartBlinking()
Sequence = Now + TimeSerial(0, 0, 1)
Worksheets("Sheet1").Range("x8").Calculate
Application.OnTime Sequence, "StartBlinking"
End Sub

Sub StopBlinking()
On Error Resume Next
Application.OnTime Sequence, "StartBlinking", Schedule:=False
End Sub


This in "immediate" window now

Application.EnableEvents = True




No other macros in workbook


HTH
Esra




On Thu, 14 Feb 2008 18:51:09 -0600, Dave Peterson
wrote:

It's time to post your macros.

What's Under the ThisWorkbook module?

What's under each (and every) general module?

Esra Dekan wrote:

Well, that doesnt work either.

I put it in there, then saved it, opened it up again, and it opened
the VBA with this error:

Compile Error:

Sub or Function not defined

Referring to this:

Private Sub Workbook_Open()
StartBlinking
End Sub

When I click off that error message, I check to see if the "immediate"
still contains that command, and although I saved it, it does not.

So, I put it back in, save again, and close the VBA and then save and
close the file, and get this message:

Compile Error:

Sub or Function not defined

Referring to this:

Private Sub Workbook_BeforeClose(Cancel As Boolean)
StopBlinking
End Sub

So, got me stumped.
I just wont have the text blinking. It would of been nice, but not
going to all this trouble for that effect.

TY for all your help everyone.

Esra

On Thu, 14 Feb 2008 15:59:00 -0600, Dave Peterson
wrote:

Open the VBE and hit ctrl-g (or view|Immediate window)

Esra Dekan wrote:

Now I am even more confused. Im so dumb when it comes to a lot of
things in Excel.

Where is the "immediate" window in VBE?

Esra

On Thu, 07 Feb 2008 20:37:39 -0800, Gord Dibben <gorddibbATshawDOTca
wrote:

Other than send you another working copy of a workbook, I see nothing else to
help you.

Well........maybe try opening the Immediate Window from VBE and copy this in and
hit ENTER

Application.EnableEvents = True


Gord

On Fri, 08 Feb 2008 15:01:24 +1300, Esra Dekan wrote:

Yes, happens in the workbook you sent, and cell b1 is just green with
text in, not blinking.

All i get in MY workbook here, is the compile error thing. I dont
know enough to know what that even means.

The Private sub thing, I right clicked "this Workbook",,,and inserted
a module, pasted the Private Sub into there.

It must be something with my excelt surely, coz it happens on the book
you sent me,,,maybe?

:((

TIA

Esra



On Thu, 07 Feb 2008 10:06:54 -0800, Gord Dibben <gorddibbATshawDOTca
wrote:

Does this occur in the workbook I sent you?

If so, have you changed anything at all?

Was working fine when I emailed the workbook to you.

"asdfg" in B1 was blinking a green color.

I still have the original if you want it re-sent.


Gord Dibben MS Excel MVP

On Thu, 07 Feb 2008 19:26:44 +1300, Esra Dekan wrote:

Still not working,

When I open the file, it comes up saying "Compile Error. Sub or
Function Not Defined"

and goes to this macro

Private Sub Workbook_Open()
StartBlinking
End Sub

When closing does the same too, goes to the macro StopBlinking


Any help??

Esra




On Sun, 03 Feb 2008 11:46:17 -0800, Gord Dibben <gorddibbATshawDOTca
wrote:

Worked fine before I sent it to you.

Did you get a message about enabling macros when you opened the workbook I sent?

If not, your macro security is set too high and Excel automatically prevents
code from running and puts the workbook in the HelpAbout MS ExcelDisabled
Items.

Have a look there first and re-enable it then reset your security level.

ToolsOptionsSecurityMacro Security.

Set it to "Medium", OK out, then close out Excel and re-open.

Enable macros when you get the message about workbook contains macros.


Gord

On Mon, 04 Feb 2008 07:38:58 +1300, Esra Dekan wrote:

That doesnt work here either.

maybe something wrong with the program? Do I need an add=in or
something?


Esra


On Sat, 02 Feb 2008 20:10:42 -0800, Gord Dibben <gorddibbATshawDOTca
wrote:

Have sent one to you.


Gord

On Sun, 03 Feb 2008 16:18:45 +1300, Esra Dekan wrote:

Maybe by chance, could someone email me a workbook with a flashing
cell? and I should be able to work it out from there.

I just cant seem to get it for some reason.

My email address is in the message i think, minus the underscore.

I wouls appreciate it

Esra

  #24   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 35,218
Default Blinking Text

Under Sheet1 "General"

Isn't right.

If the code is behind a worksheet, then it's not in the right place.

Select your project in the VBE
Insert|Module
Paste the code in that newly opened window.
Delete the code from behind Sheet1.

Esra Dekan wrote:

Under ThisWorkbook

Private Sub Workbook_Open()
StartBlinking
End Sub

Private Sub Workbook_BeforeClose(Cancel As Boolean)
StopBlinking
End Sub

Under Sheet1 "General"

Sub StartBlinking()
Sequence = Now + TimeSerial(0, 0, 1)
Worksheets("Sheet1").Range("x8").Calculate
Application.OnTime Sequence, "StartBlinking"
End Sub

Sub StopBlinking()
On Error Resume Next
Application.OnTime Sequence, "StartBlinking", Schedule:=False
End Sub

This in "immediate" window now

Application.EnableEvents = True

No other macros in workbook

HTH
Esra

On Thu, 14 Feb 2008 18:51:09 -0600, Dave Peterson
wrote:

It's time to post your macros.

What's Under the ThisWorkbook module?

What's under each (and every) general module?

Esra Dekan wrote:

Well, that doesnt work either.

I put it in there, then saved it, opened it up again, and it opened
the VBA with this error:

Compile Error:

Sub or Function not defined

Referring to this:

Private Sub Workbook_Open()
StartBlinking
End Sub

When I click off that error message, I check to see if the "immediate"
still contains that command, and although I saved it, it does not.

So, I put it back in, save again, and close the VBA and then save and
close the file, and get this message:

Compile Error:

Sub or Function not defined

Referring to this:

Private Sub Workbook_BeforeClose(Cancel As Boolean)
StopBlinking
End Sub

So, got me stumped.
I just wont have the text blinking. It would of been nice, but not
going to all this trouble for that effect.

TY for all your help everyone.

Esra

On Thu, 14 Feb 2008 15:59:00 -0600, Dave Peterson
wrote:

Open the VBE and hit ctrl-g (or view|Immediate window)

Esra Dekan wrote:

Now I am even more confused. Im so dumb when it comes to a lot of
things in Excel.

Where is the "immediate" window in VBE?

Esra

On Thu, 07 Feb 2008 20:37:39 -0800, Gord Dibben <gorddibbATshawDOTca
wrote:

Other than send you another working copy of a workbook, I see nothing else to
help you.

Well........maybe try opening the Immediate Window from VBE and copy this in and
hit ENTER

Application.EnableEvents = True


Gord

On Fri, 08 Feb 2008 15:01:24 +1300, Esra Dekan wrote:

Yes, happens in the workbook you sent, and cell b1 is just green with
text in, not blinking.

All i get in MY workbook here, is the compile error thing. I dont
know enough to know what that even means.

The Private sub thing, I right clicked "this Workbook",,,and inserted
a module, pasted the Private Sub into there.

It must be something with my excelt surely, coz it happens on the book
you sent me,,,maybe?

:((

TIA

Esra



On Thu, 07 Feb 2008 10:06:54 -0800, Gord Dibben <gorddibbATshawDOTca
wrote:

Does this occur in the workbook I sent you?

If so, have you changed anything at all?

Was working fine when I emailed the workbook to you.

"asdfg" in B1 was blinking a green color.

I still have the original if you want it re-sent.


Gord Dibben MS Excel MVP

On Thu, 07 Feb 2008 19:26:44 +1300, Esra Dekan wrote:

Still not working,

When I open the file, it comes up saying "Compile Error. Sub or
Function Not Defined"

and goes to this macro

Private Sub Workbook_Open()
StartBlinking
End Sub

When closing does the same too, goes to the macro StopBlinking


Any help??

Esra




On Sun, 03 Feb 2008 11:46:17 -0800, Gord Dibben <gorddibbATshawDOTca
wrote:

Worked fine before I sent it to you.

Did you get a message about enabling macros when you opened the workbook I sent?

If not, your macro security is set too high and Excel automatically prevents
code from running and puts the workbook in the HelpAbout MS ExcelDisabled
Items.

Have a look there first and re-enable it then reset your security level.

ToolsOptionsSecurityMacro Security.

Set it to "Medium", OK out, then close out Excel and re-open.

Enable macros when you get the message about workbook contains macros.


Gord

On Mon, 04 Feb 2008 07:38:58 +1300, Esra Dekan wrote:

That doesnt work here either.

maybe something wrong with the program? Do I need an add=in or
something?


Esra


On Sat, 02 Feb 2008 20:10:42 -0800, Gord Dibben <gorddibbATshawDOTca
wrote:

Have sent one to you.


Gord

On Sun, 03 Feb 2008 16:18:45 +1300, Esra Dekan wrote:

Maybe by chance, could someone email me a workbook with a flashing
cell? and I should be able to work it out from there.

I just cant seem to get it for some reason.

My email address is in the message i think, minus the underscore.

I wouls appreciate it

Esra


--

Dave Peterson
  #25   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 22
Default Blinking Text

OK, (my mistake, I just assumed it went there)
that stops the compile error thing coming up and seems to be ok,
but text still doesnt blink in the requested cell.

Any ideas?

Esra


On Fri, 15 Feb 2008 10:47:53 -0600, Dave Peterson
wrote:

Under Sheet1 "General"

Isn't right.

If the code is behind a worksheet, then it's not in the right place.

Select your project in the VBE
Insert|Module
Paste the code in that newly opened window.
Delete the code from behind Sheet1.

Esra Dekan wrote:

Under ThisWorkbook

Private Sub Workbook_Open()
StartBlinking
End Sub

Private Sub Workbook_BeforeClose(Cancel As Boolean)
StopBlinking
End Sub

Under Sheet1 "General"

Sub StartBlinking()
Sequence = Now + TimeSerial(0, 0, 1)
Worksheets("Sheet1").Range("x8").Calculate
Application.OnTime Sequence, "StartBlinking"
End Sub

Sub StopBlinking()
On Error Resume Next
Application.OnTime Sequence, "StartBlinking", Schedule:=False
End Sub

This in "immediate" window now

Application.EnableEvents = True

No other macros in workbook

HTH
Esra

On Thu, 14 Feb 2008 18:51:09 -0600, Dave Peterson
wrote:

It's time to post your macros.

What's Under the ThisWorkbook module?

What's under each (and every) general module?

Esra Dekan wrote:

Well, that doesnt work either.

I put it in there, then saved it, opened it up again, and it opened
the VBA with this error:

Compile Error:

Sub or Function not defined

Referring to this:

Private Sub Workbook_Open()
StartBlinking
End Sub

When I click off that error message, I check to see if the "immediate"
still contains that command, and although I saved it, it does not.

So, I put it back in, save again, and close the VBA and then save and
close the file, and get this message:

Compile Error:

Sub or Function not defined

Referring to this:

Private Sub Workbook_BeforeClose(Cancel As Boolean)
StopBlinking
End Sub

So, got me stumped.
I just wont have the text blinking. It would of been nice, but not
going to all this trouble for that effect.

TY for all your help everyone.

Esra

On Thu, 14 Feb 2008 15:59:00 -0600, Dave Peterson
wrote:

Open the VBE and hit ctrl-g (or view|Immediate window)

Esra Dekan wrote:

Now I am even more confused. Im so dumb when it comes to a lot of
things in Excel.

Where is the "immediate" window in VBE?

Esra

On Thu, 07 Feb 2008 20:37:39 -0800, Gord Dibben <gorddibbATshawDOTca
wrote:

Other than send you another working copy of a workbook, I see nothing else to
help you.

Well........maybe try opening the Immediate Window from VBE and copy this in and
hit ENTER

Application.EnableEvents = True


Gord

On Fri, 08 Feb 2008 15:01:24 +1300, Esra Dekan wrote:

Yes, happens in the workbook you sent, and cell b1 is just green with
text in, not blinking.

All i get in MY workbook here, is the compile error thing. I dont
know enough to know what that even means.

The Private sub thing, I right clicked "this Workbook",,,and inserted
a module, pasted the Private Sub into there.

It must be something with my excelt surely, coz it happens on the book
you sent me,,,maybe?

:((

TIA

Esra



On Thu, 07 Feb 2008 10:06:54 -0800, Gord Dibben <gorddibbATshawDOTca
wrote:

Does this occur in the workbook I sent you?

If so, have you changed anything at all?

Was working fine when I emailed the workbook to you.

"asdfg" in B1 was blinking a green color.

I still have the original if you want it re-sent.


Gord Dibben MS Excel MVP

On Thu, 07 Feb 2008 19:26:44 +1300, Esra Dekan wrote:

Still not working,

When I open the file, it comes up saying "Compile Error. Sub or
Function Not Defined"

and goes to this macro

Private Sub Workbook_Open()
StartBlinking
End Sub

When closing does the same too, goes to the macro StopBlinking


Any help??

Esra




On Sun, 03 Feb 2008 11:46:17 -0800, Gord Dibben <gorddibbATshawDOTca
wrote:

Worked fine before I sent it to you.

Did you get a message about enabling macros when you opened the workbook I sent?

If not, your macro security is set too high and Excel automatically prevents
code from running and puts the workbook in the HelpAbout MS ExcelDisabled
Items.

Have a look there first and re-enable it then reset your security level.

ToolsOptionsSecurityMacro Security.

Set it to "Medium", OK out, then close out Excel and re-open.

Enable macros when you get the message about workbook contains macros.


Gord

On Mon, 04 Feb 2008 07:38:58 +1300, Esra Dekan wrote:

That doesnt work here either.

maybe something wrong with the program? Do I need an add=in or
something?


Esra


On Sat, 02 Feb 2008 20:10:42 -0800, Gord Dibben <gorddibbATshawDOTca
wrote:

Have sent one to you.


Gord

On Sun, 03 Feb 2008 16:18:45 +1300, Esra Dekan wrote:

Maybe by chance, could someone email me a workbook with a flashing
cell? and I should be able to work it out from there.

I just cant seem to get it for some reason.

My email address is in the message i think, minus the underscore.

I wouls appreciate it

Esra



  #26   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 22,906
Default Blinking Text

Esra

Why would assume that when you were given specific instructions to the contrary?

Quoted directly from my second post........................

a) Copy these two macros to a general code module:
=================

Option Private Module
Public Sequence As Date
Sub StartBlinking()
Sequence = Now + TimeSerial(0, 0, 1)
Worksheets("MySheet").Range("B1").Calculate
Application.OnTime Sequence, "StartBlinking"
End Sub

Sub StopBlinking()
On Error Resume Next
Application.OnTime Sequence, "StartBlinking", Schedule:=False
End Sub

===================

b) Copy these two events to 'ThisWorkbook' code module:
===================

Private Sub Workbook_Open()
StartBlinking
End Sub

Private Sub Workbook_BeforeClose(Cancel As Boolean)
StopBlinking
End Sub

End quote..................................

And the other instructions I gave was for you enter

Aplication.EnableEvents = True into the Immediate window.

Sounds like you placed your workbook_open code into the Immediate window.



Gord Dibben MS Excel MVP



On Sat, 16 Feb 2008 09:34:58 +1300, Esra Dekan wrote:

OK, (my mistake, I just assumed it went there)
that stops the compile error thing coming up and seems to be ok,
but text still doesnt blink in the requested cell.

Any ideas?

Esra


On Fri, 15 Feb 2008 10:47:53 -0600, Dave Peterson
wrote:

Under Sheet1 "General"

Isn't right.

If the code is behind a worksheet, then it's not in the right place.

Select your project in the VBE
Insert|Module
Paste the code in that newly opened window.
Delete the code from behind Sheet1.

Esra Dekan wrote:

Under ThisWorkbook

Private Sub Workbook_Open()
StartBlinking
End Sub

Private Sub Workbook_BeforeClose(Cancel As Boolean)
StopBlinking
End Sub

Under Sheet1 "General"

Sub StartBlinking()
Sequence = Now + TimeSerial(0, 0, 1)
Worksheets("Sheet1").Range("x8").Calculate
Application.OnTime Sequence, "StartBlinking"
End Sub

Sub StopBlinking()
On Error Resume Next
Application.OnTime Sequence, "StartBlinking", Schedule:=False
End Sub

This in "immediate" window now

Application.EnableEvents = True

No other macros in workbook

HTH
Esra

On Thu, 14 Feb 2008 18:51:09 -0600, Dave Peterson
wrote:

It's time to post your macros.

What's Under the ThisWorkbook module?

What's under each (and every) general module?

Esra Dekan wrote:

Well, that doesnt work either.

I put it in there, then saved it, opened it up again, and it opened
the VBA with this error:

Compile Error:

Sub or Function not defined

Referring to this:

Private Sub Workbook_Open()
StartBlinking
End Sub

When I click off that error message, I check to see if the "immediate"
still contains that command, and although I saved it, it does not.

So, I put it back in, save again, and close the VBA and then save and
close the file, and get this message:

Compile Error:

Sub or Function not defined

Referring to this:

Private Sub Workbook_BeforeClose(Cancel As Boolean)
StopBlinking
End Sub

So, got me stumped.
I just wont have the text blinking. It would of been nice, but not
going to all this trouble for that effect.

TY for all your help everyone.

Esra

On Thu, 14 Feb 2008 15:59:00 -0600, Dave Peterson
wrote:

Open the VBE and hit ctrl-g (or view|Immediate window)

Esra Dekan wrote:

Now I am even more confused. Im so dumb when it comes to a lot of
things in Excel.

Where is the "immediate" window in VBE?

Esra

On Thu, 07 Feb 2008 20:37:39 -0800, Gord Dibben <gorddibbATshawDOTca
wrote:

Other than send you another working copy of a workbook, I see nothing else to
help you.

Well........maybe try opening the Immediate Window from VBE and copy this in and
hit ENTER

Application.EnableEvents = True


Gord

On Fri, 08 Feb 2008 15:01:24 +1300, Esra Dekan wrote:

Yes, happens in the workbook you sent, and cell b1 is just green with
text in, not blinking.

All i get in MY workbook here, is the compile error thing. I dont
know enough to know what that even means.

The Private sub thing, I right clicked "this Workbook",,,and inserted
a module, pasted the Private Sub into there.

It must be something with my excelt surely, coz it happens on the book
you sent me,,,maybe?

:((

TIA

Esra



On Thu, 07 Feb 2008 10:06:54 -0800, Gord Dibben <gorddibbATshawDOTca
wrote:

Does this occur in the workbook I sent you?

If so, have you changed anything at all?

Was working fine when I emailed the workbook to you.

"asdfg" in B1 was blinking a green color.

I still have the original if you want it re-sent.


Gord Dibben MS Excel MVP

On Thu, 07 Feb 2008 19:26:44 +1300, Esra Dekan wrote:

Still not working,

When I open the file, it comes up saying "Compile Error. Sub or
Function Not Defined"

and goes to this macro

Private Sub Workbook_Open()
StartBlinking
End Sub

When closing does the same too, goes to the macro StopBlinking


Any help??

Esra




On Sun, 03 Feb 2008 11:46:17 -0800, Gord Dibben <gorddibbATshawDOTca
wrote:

Worked fine before I sent it to you.

Did you get a message about enabling macros when you opened the workbook I sent?

If not, your macro security is set too high and Excel automatically prevents
code from running and puts the workbook in the HelpAbout MS ExcelDisabled
Items.

Have a look there first and re-enable it then reset your security level.

ToolsOptionsSecurityMacro Security.

Set it to "Medium", OK out, then close out Excel and re-open.

Enable macros when you get the message about workbook contains macros.


Gord

On Mon, 04 Feb 2008 07:38:58 +1300, Esra Dekan wrote:

That doesnt work here either.

maybe something wrong with the program? Do I need an add=in or
something?


Esra


On Sat, 02 Feb 2008 20:10:42 -0800, Gord Dibben <gorddibbATshawDOTca
wrote:

Have sent one to you.


Gord

On Sun, 03 Feb 2008 16:18:45 +1300, Esra Dekan wrote:

Maybe by chance, could someone email me a workbook with a flashing
cell? and I should be able to work it out from there.

I just cant seem to get it for some reason.

My email address is in the message i think, minus the underscore.

I wouls appreciate it

Esra


  #27   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 22
Default Blinking Text

If I didnt post things in the right location thnen it is purely
because I didnt understand what you are telling me to do.

Excuse me for being ignorant abouit it, its why I am asking for help,
coz I dont know.

I didnt even know an "immediate" window existed until a very recent
post of yours when you told me how to get to it so how could I have
posted all this stuff to the immediate window.

Also, I just posted to you, telling you where things are and I only
have one thing in immediate window in that post dont i?

Look, dont worry about it, its not life or death that I get this done,
I will just do without it.

And I resent your ciomment "Why would assume that when you were given
specific instructions to the contrary?", it was uncalled for. Dont
make people out to be dumb.

Esra




On Fri, 15 Feb 2008 13:21:44 -0800, Gord Dibben <gorddibbATshawDOTca
wrote:

Esra

Why would assume that when you were given specific instructions to the contrary?

Quoted directly from my second post........................

a) Copy these two macros to a general code module:
=================

Option Private Module
Public Sequence As Date
Sub StartBlinking()
Sequence = Now + TimeSerial(0, 0, 1)
Worksheets("MySheet").Range("B1").Calculate
Application.OnTime Sequence, "StartBlinking"
End Sub

Sub StopBlinking()
On Error Resume Next
Application.OnTime Sequence, "StartBlinking", Schedule:=False
End Sub

===================

b) Copy these two events to 'ThisWorkbook' code module:
===================

Private Sub Workbook_Open()
StartBlinking
End Sub

Private Sub Workbook_BeforeClose(Cancel As Boolean)
StopBlinking
End Sub

End quote..................................

And the other instructions I gave was for you enter

Aplication.EnableEvents = True into the Immediate window.

Sounds like you placed your workbook_open code into the Immediate window.



Gord Dibben MS Excel MVP



On Sat, 16 Feb 2008 09:34:58 +1300, Esra Dekan wrote:

OK, (my mistake, I just assumed it went there)
that stops the compile error thing coming up and seems to be ok,
but text still doesnt blink in the requested cell.

Any ideas?

Esra


On Fri, 15 Feb 2008 10:47:53 -0600, Dave Peterson
wrote:

Under Sheet1 "General"

Isn't right.

If the code is behind a worksheet, then it's not in the right place.

Select your project in the VBE
Insert|Module
Paste the code in that newly opened window.
Delete the code from behind Sheet1.

Esra Dekan wrote:

Under ThisWorkbook

Private Sub Workbook_Open()
StartBlinking
End Sub

Private Sub Workbook_BeforeClose(Cancel As Boolean)
StopBlinking
End Sub

Under Sheet1 "General"

Sub StartBlinking()
Sequence = Now + TimeSerial(0, 0, 1)
Worksheets("Sheet1").Range("x8").Calculate
Application.OnTime Sequence, "StartBlinking"
End Sub

Sub StopBlinking()
On Error Resume Next
Application.OnTime Sequence, "StartBlinking", Schedule:=False
End Sub

This in "immediate" window now

Application.EnableEvents = True

No other macros in workbook

HTH
Esra

On Thu, 14 Feb 2008 18:51:09 -0600, Dave Peterson
wrote:

It's time to post your macros.

What's Under the ThisWorkbook module?

What's under each (and every) general module?

Esra Dekan wrote:

Well, that doesnt work either.

I put it in there, then saved it, opened it up again, and it opened
the VBA with this error:

Compile Error:

Sub or Function not defined

Referring to this:

Private Sub Workbook_Open()
StartBlinking
End Sub

When I click off that error message, I check to see if the "immediate"
still contains that command, and although I saved it, it does not.

So, I put it back in, save again, and close the VBA and then save and
close the file, and get this message:

Compile Error:

Sub or Function not defined

Referring to this:

Private Sub Workbook_BeforeClose(Cancel As Boolean)
StopBlinking
End Sub

So, got me stumped.
I just wont have the text blinking. It would of been nice, but not
going to all this trouble for that effect.

TY for all your help everyone.

Esra

On Thu, 14 Feb 2008 15:59:00 -0600, Dave Peterson
wrote:

Open the VBE and hit ctrl-g (or view|Immediate window)

Esra Dekan wrote:

Now I am even more confused. Im so dumb when it comes to a lot of
things in Excel.

Where is the "immediate" window in VBE?

Esra

On Thu, 07 Feb 2008 20:37:39 -0800, Gord Dibben <gorddibbATshawDOTca
wrote:

Other than send you another working copy of a workbook, I see nothing else to
help you.

Well........maybe try opening the Immediate Window from VBE and copy this in and
hit ENTER

Application.EnableEvents = True


Gord

On Fri, 08 Feb 2008 15:01:24 +1300, Esra Dekan wrote:

Yes, happens in the workbook you sent, and cell b1 is just green with
text in, not blinking.

All i get in MY workbook here, is the compile error thing. I dont
know enough to know what that even means.

The Private sub thing, I right clicked "this Workbook",,,and inserted
a module, pasted the Private Sub into there.

It must be something with my excelt surely, coz it happens on the book
you sent me,,,maybe?

:((

TIA

Esra



On Thu, 07 Feb 2008 10:06:54 -0800, Gord Dibben <gorddibbATshawDOTca
wrote:

Does this occur in the workbook I sent you?

If so, have you changed anything at all?

Was working fine when I emailed the workbook to you.

"asdfg" in B1 was blinking a green color.

I still have the original if you want it re-sent.


Gord Dibben MS Excel MVP

On Thu, 07 Feb 2008 19:26:44 +1300, Esra Dekan wrote:

Still not working,

When I open the file, it comes up saying "Compile Error. Sub or
Function Not Defined"

and goes to this macro

Private Sub Workbook_Open()
StartBlinking
End Sub

When closing does the same too, goes to the macro StopBlinking


Any help??

Esra




On Sun, 03 Feb 2008 11:46:17 -0800, Gord Dibben <gorddibbATshawDOTca
wrote:

Worked fine before I sent it to you.

Did you get a message about enabling macros when you opened the workbook I sent?

If not, your macro security is set too high and Excel automatically prevents
code from running and puts the workbook in the HelpAbout MS ExcelDisabled
Items.

Have a look there first and re-enable it then reset your security level.

ToolsOptionsSecurityMacro Security.

Set it to "Medium", OK out, then close out Excel and re-open.

Enable macros when you get the message about workbook contains macros.


Gord

On Mon, 04 Feb 2008 07:38:58 +1300, Esra Dekan wrote:

That doesnt work here either.

maybe something wrong with the program? Do I need an add=in or
something?


Esra


On Sat, 02 Feb 2008 20:10:42 -0800, Gord Dibben <gorddibbATshawDOTca
wrote:

Have sent one to you.


Gord

On Sun, 03 Feb 2008 16:18:45 +1300, Esra Dekan wrote:

Maybe by chance, could someone email me a workbook with a flashing
cell? and I should be able to work it out from there.

I just cant seem to get it for some reason.

My email address is in the message i think, minus the underscore.

I wouls appreciate it

Esra

  #28   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 22,906
Default Blinking Text

The only thing I asked you to put in the Immediate window in the workbook I sent
to you was

Application.EnableEvents = True

The reason for that was to make sure events were enabled.

If you do that, close the workbook and re-open the green text should blink.

My comment was not intended to make you out to be dumb.......dumb is your word,
not mine.

It was intended only to prod you to read things a little more closely when you
are given instructions.

You and anyone else using the workbook are much better off without the annoyance
of blinking text, so abandoning the idea is a good decision.

Apologies for upsetting you.

I guess my people-skills are drifting away with the other wearing-out parts.


Gord



On Sun, 17 Feb 2008 10:17:12 +1300, Esra Dekan wrote:

If I didnt post things in the right location thnen it is purely
because I didnt understand what you are telling me to do.

Excuse me for being ignorant abouit it, its why I am asking for help,
coz I dont know.

I didnt even know an "immediate" window existed until a very recent
post of yours when you told me how to get to it so how could I have
posted all this stuff to the immediate window.

Also, I just posted to you, telling you where things are and I only
have one thing in immediate window in that post dont i?

Look, dont worry about it, its not life or death that I get this done,
I will just do without it.

And I resent your ciomment "Why would assume that when you were given
specific instructions to the contrary?", it was uncalled for. Dont
make people out to be dumb.

Esra




On Fri, 15 Feb 2008 13:21:44 -0800, Gord Dibben <gorddibbATshawDOTca
wrote:

Esra

Why would assume that when you were given specific instructions to the contrary?

Quoted directly from my second post........................

a) Copy these two macros to a general code module:
=================

Option Private Module
Public Sequence As Date
Sub StartBlinking()
Sequence = Now + TimeSerial(0, 0, 1)
Worksheets("MySheet").Range("B1").Calculate
Application.OnTime Sequence, "StartBlinking"
End Sub

Sub StopBlinking()
On Error Resume Next
Application.OnTime Sequence, "StartBlinking", Schedule:=False
End Sub

===================

b) Copy these two events to 'ThisWorkbook' code module:
===================

Private Sub Workbook_Open()
StartBlinking
End Sub

Private Sub Workbook_BeforeClose(Cancel As Boolean)
StopBlinking
End Sub

End quote..................................

And the other instructions I gave was for you enter

Aplication.EnableEvents = True into the Immediate window.

Sounds like you placed your workbook_open code into the Immediate window.



Gord Dibben MS Excel MVP



On Sat, 16 Feb 2008 09:34:58 +1300, Esra Dekan wrote:

OK, (my mistake, I just assumed it went there)
that stops the compile error thing coming up and seems to be ok,
but text still doesnt blink in the requested cell.

Any ideas?

Esra


On Fri, 15 Feb 2008 10:47:53 -0600, Dave Peterson
wrote:

Under Sheet1 "General"

Isn't right.

If the code is behind a worksheet, then it's not in the right place.

Select your project in the VBE
Insert|Module
Paste the code in that newly opened window.
Delete the code from behind Sheet1.

Esra Dekan wrote:

Under ThisWorkbook

Private Sub Workbook_Open()
StartBlinking
End Sub

Private Sub Workbook_BeforeClose(Cancel As Boolean)
StopBlinking
End Sub

Under Sheet1 "General"

Sub StartBlinking()
Sequence = Now + TimeSerial(0, 0, 1)
Worksheets("Sheet1").Range("x8").Calculate
Application.OnTime Sequence, "StartBlinking"
End Sub

Sub StopBlinking()
On Error Resume Next
Application.OnTime Sequence, "StartBlinking", Schedule:=False
End Sub

This in "immediate" window now

Application.EnableEvents = True

No other macros in workbook

HTH
Esra

On Thu, 14 Feb 2008 18:51:09 -0600, Dave Peterson
wrote:

It's time to post your macros.

What's Under the ThisWorkbook module?

What's under each (and every) general module?

Esra Dekan wrote:

Well, that doesnt work either.

I put it in there, then saved it, opened it up again, and it opened
the VBA with this error:

Compile Error:

Sub or Function not defined

Referring to this:

Private Sub Workbook_Open()
StartBlinking
End Sub

When I click off that error message, I check to see if the "immediate"
still contains that command, and although I saved it, it does not.

So, I put it back in, save again, and close the VBA and then save and
close the file, and get this message:

Compile Error:

Sub or Function not defined

Referring to this:

Private Sub Workbook_BeforeClose(Cancel As Boolean)
StopBlinking
End Sub

So, got me stumped.
I just wont have the text blinking. It would of been nice, but not
going to all this trouble for that effect.

TY for all your help everyone.

Esra

On Thu, 14 Feb 2008 15:59:00 -0600, Dave Peterson
wrote:

Open the VBE and hit ctrl-g (or view|Immediate window)

Esra Dekan wrote:

Now I am even more confused. Im so dumb when it comes to a lot of
things in Excel.

Where is the "immediate" window in VBE?

Esra

On Thu, 07 Feb 2008 20:37:39 -0800, Gord Dibben <gorddibbATshawDOTca
wrote:

Other than send you another working copy of a workbook, I see nothing else to
help you.

Well........maybe try opening the Immediate Window from VBE and copy this in and
hit ENTER

Application.EnableEvents = True


Gord

On Fri, 08 Feb 2008 15:01:24 +1300, Esra Dekan wrote:

Yes, happens in the workbook you sent, and cell b1 is just green with
text in, not blinking.

All i get in MY workbook here, is the compile error thing. I dont
know enough to know what that even means.

The Private sub thing, I right clicked "this Workbook",,,and inserted
a module, pasted the Private Sub into there.

It must be something with my excelt surely, coz it happens on the book
you sent me,,,maybe?

:((

TIA

Esra



On Thu, 07 Feb 2008 10:06:54 -0800, Gord Dibben <gorddibbATshawDOTca
wrote:

Does this occur in the workbook I sent you?

If so, have you changed anything at all?

Was working fine when I emailed the workbook to you.

"asdfg" in B1 was blinking a green color.

I still have the original if you want it re-sent.


Gord Dibben MS Excel MVP

On Thu, 07 Feb 2008 19:26:44 +1300, Esra Dekan wrote:

Still not working,

When I open the file, it comes up saying "Compile Error. Sub or
Function Not Defined"

and goes to this macro

Private Sub Workbook_Open()
StartBlinking
End Sub

When closing does the same too, goes to the macro StopBlinking


Any help??

Esra




On Sun, 03 Feb 2008 11:46:17 -0800, Gord Dibben <gorddibbATshawDOTca
wrote:

Worked fine before I sent it to you.

Did you get a message about enabling macros when you opened the workbook I sent?

If not, your macro security is set too high and Excel automatically prevents
code from running and puts the workbook in the HelpAbout MS ExcelDisabled
Items.

Have a look there first and re-enable it then reset your security level.

ToolsOptionsSecurityMacro Security.

Set it to "Medium", OK out, then close out Excel and re-open.

Enable macros when you get the message about workbook contains macros.


Gord

On Mon, 04 Feb 2008 07:38:58 +1300, Esra Dekan wrote:

That doesnt work here either.

maybe something wrong with the program? Do I need an add=in or
something?


Esra


On Sat, 02 Feb 2008 20:10:42 -0800, Gord Dibben <gorddibbATshawDOTca
wrote:

Have sent one to you.


Gord

On Sun, 03 Feb 2008 16:18:45 +1300, Esra Dekan wrote:

Maybe by chance, could someone email me a workbook with a flashing
cell? and I should be able to work it out from there.

I just cant seem to get it for some reason.

My email address is in the message i think, minus the underscore.

I wouls appreciate it

Esra


  #29   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 22
Default Blinking Text

And i started out by saying "I know it is frowned on but", so you
would think i aheva specifc reason for it, and the reason is not
distracting, when reading the worksheet, because there is only one
thing on the worksheet.

Sorry if you dont agree with me wanting to have that effect.

Decison made, I wont now.



On Sat, 16 Feb 2008 14:12:40 -0800, Gord Dibben <gorddibbATshawDOTca
wrote:

The only thing I asked you to put in the Immediate window in the workbook I sent
to you was

Application.EnableEvents = True

The reason for that was to make sure events were enabled.

If you do that, close the workbook and re-open the green text should blink.

My comment was not intended to make you out to be dumb.......dumb is your word,
not mine.

It was intended only to prod you to read things a little more closely when you
are given instructions.

You and anyone else using the workbook are much better off without the annoyance
of blinking text, so abandoning the idea is a good decision.

Apologies for upsetting you.

I guess my people-skills are drifting away with the other wearing-out parts.


Gord



On Sun, 17 Feb 2008 10:17:12 +1300, Esra Dekan wrote:

If I didnt post things in the right location thnen it is purely
because I didnt understand what you are telling me to do.

Excuse me for being ignorant abouit it, its why I am asking for help,
coz I dont know.

I didnt even know an "immediate" window existed until a very recent
post of yours when you told me how to get to it so how could I have
posted all this stuff to the immediate window.

Also, I just posted to you, telling you where things are and I only
have one thing in immediate window in that post dont i?

Look, dont worry about it, its not life or death that I get this done,
I will just do without it.

And I resent your ciomment "Why would assume that when you were given
specific instructions to the contrary?", it was uncalled for. Dont
make people out to be dumb.

Esra




On Fri, 15 Feb 2008 13:21:44 -0800, Gord Dibben <gorddibbATshawDOTca
wrote:

Esra

Why would assume that when you were given specific instructions to the contrary?

Quoted directly from my second post........................

a) Copy these two macros to a general code module:
=================

Option Private Module
Public Sequence As Date
Sub StartBlinking()
Sequence = Now + TimeSerial(0, 0, 1)
Worksheets("MySheet").Range("B1").Calculate
Application.OnTime Sequence, "StartBlinking"
End Sub

Sub StopBlinking()
On Error Resume Next
Application.OnTime Sequence, "StartBlinking", Schedule:=False
End Sub

===================

b) Copy these two events to 'ThisWorkbook' code module:
===================

Private Sub Workbook_Open()
StartBlinking
End Sub

Private Sub Workbook_BeforeClose(Cancel As Boolean)
StopBlinking
End Sub

End quote..................................

And the other instructions I gave was for you enter

Aplication.EnableEvents = True into the Immediate window.

Sounds like you placed your workbook_open code into the Immediate window.



Gord Dibben MS Excel MVP



On Sat, 16 Feb 2008 09:34:58 +1300, Esra Dekan wrote:

OK, (my mistake, I just assumed it went there)
that stops the compile error thing coming up and seems to be ok,
but text still doesnt blink in the requested cell.

Any ideas?

Esra


On Fri, 15 Feb 2008 10:47:53 -0600, Dave Peterson
wrote:

Under Sheet1 "General"

Isn't right.

If the code is behind a worksheet, then it's not in the right place.

Select your project in the VBE
Insert|Module
Paste the code in that newly opened window.
Delete the code from behind Sheet1.

Esra Dekan wrote:

Under ThisWorkbook

Private Sub Workbook_Open()
StartBlinking
End Sub

Private Sub Workbook_BeforeClose(Cancel As Boolean)
StopBlinking
End Sub

Under Sheet1 "General"

Sub StartBlinking()
Sequence = Now + TimeSerial(0, 0, 1)
Worksheets("Sheet1").Range("x8").Calculate
Application.OnTime Sequence, "StartBlinking"
End Sub

Sub StopBlinking()
On Error Resume Next
Application.OnTime Sequence, "StartBlinking", Schedule:=False
End Sub

This in "immediate" window now

Application.EnableEvents = True

No other macros in workbook

HTH
Esra

On Thu, 14 Feb 2008 18:51:09 -0600, Dave Peterson
wrote:

It's time to post your macros.

What's Under the ThisWorkbook module?

What's under each (and every) general module?

Esra Dekan wrote:

Well, that doesnt work either.

I put it in there, then saved it, opened it up again, and it opened
the VBA with this error:

Compile Error:

Sub or Function not defined

Referring to this:

Private Sub Workbook_Open()
StartBlinking
End Sub

When I click off that error message, I check to see if the "immediate"
still contains that command, and although I saved it, it does not.

So, I put it back in, save again, and close the VBA and then save and
close the file, and get this message:

Compile Error:

Sub or Function not defined

Referring to this:

Private Sub Workbook_BeforeClose(Cancel As Boolean)
StopBlinking
End Sub

So, got me stumped.
I just wont have the text blinking. It would of been nice, but not
going to all this trouble for that effect.

TY for all your help everyone.

Esra

On Thu, 14 Feb 2008 15:59:00 -0600, Dave Peterson
wrote:

Open the VBE and hit ctrl-g (or view|Immediate window)

Esra Dekan wrote:

Now I am even more confused. Im so dumb when it comes to a lot of
things in Excel.

Where is the "immediate" window in VBE?

Esra

On Thu, 07 Feb 2008 20:37:39 -0800, Gord Dibben <gorddibbATshawDOTca
wrote:

Other than send you another working copy of a workbook, I see nothing else to
help you.

Well........maybe try opening the Immediate Window from VBE and copy this in and
hit ENTER

Application.EnableEvents = True


Gord

On Fri, 08 Feb 2008 15:01:24 +1300, Esra Dekan wrote:

Yes, happens in the workbook you sent, and cell b1 is just green with
text in, not blinking.

All i get in MY workbook here, is the compile error thing. I dont
know enough to know what that even means.

The Private sub thing, I right clicked "this Workbook",,,and inserted
a module, pasted the Private Sub into there.

It must be something with my excelt surely, coz it happens on the book
you sent me,,,maybe?

:((

TIA

Esra



On Thu, 07 Feb 2008 10:06:54 -0800, Gord Dibben <gorddibbATshawDOTca
wrote:

Does this occur in the workbook I sent you?

If so, have you changed anything at all?

Was working fine when I emailed the workbook to you.

"asdfg" in B1 was blinking a green color.

I still have the original if you want it re-sent.


Gord Dibben MS Excel MVP

On Thu, 07 Feb 2008 19:26:44 +1300, Esra Dekan wrote:

Still not working,

When I open the file, it comes up saying "Compile Error. Sub or
Function Not Defined"

and goes to this macro

Private Sub Workbook_Open()
StartBlinking
End Sub

When closing does the same too, goes to the macro StopBlinking


Any help??

Esra




On Sun, 03 Feb 2008 11:46:17 -0800, Gord Dibben <gorddibbATshawDOTca
wrote:

Worked fine before I sent it to you.

Did you get a message about enabling macros when you opened the workbook I sent?

If not, your macro security is set too high and Excel automatically prevents
code from running and puts the workbook in the HelpAbout MS ExcelDisabled
Items.

Have a look there first and re-enable it then reset your security level.

ToolsOptionsSecurityMacro Security.

Set it to "Medium", OK out, then close out Excel and re-open.

Enable macros when you get the message about workbook contains macros.


Gord

On Mon, 04 Feb 2008 07:38:58 +1300, Esra Dekan wrote:

That doesnt work here either.

maybe something wrong with the program? Do I need an add=in or
something?


Esra


On Sat, 02 Feb 2008 20:10:42 -0800, Gord Dibben <gorddibbATshawDOTca
wrote:

Have sent one to you.


Gord

On Sun, 03 Feb 2008 16:18:45 +1300, Esra Dekan wrote:

Maybe by chance, could someone email me a workbook with a flashing
cell? and I should be able to work it out from there.

I just cant seem to get it for some reason.

My email address is in the message i think, minus the underscore.

I wouls appreciate it

Esra

  #30   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 22
Default Blinking Text

Oh and its also worth pointing out, that the workbook you sent me that
is supposed to have blinking in it, has all the commands in exactly
the same places as I do in my workbook, and it TOO doesnt work.

I suggest something might have been overlooked.

Esra



On Sat, 16 Feb 2008 14:12:40 -0800, Gord Dibben <gorddibbATshawDOTca
wrote:

The only thing I asked you to put in the Immediate window in the workbook I sent
to you was

Application.EnableEvents = True

The reason for that was to make sure events were enabled.

If you do that, close the workbook and re-open the green text should blink.

My comment was not intended to make you out to be dumb.......dumb is your word,
not mine.

It was intended only to prod you to read things a little more closely when you
are given instructions.

You and anyone else using the workbook are much better off without the annoyance
of blinking text, so abandoning the idea is a good decision.

Apologies for upsetting you.

I guess my people-skills are drifting away with the other wearing-out parts.


Gord



On Sun, 17 Feb 2008 10:17:12 +1300, Esra Dekan wrote:

If I didnt post things in the right location thnen it is purely
because I didnt understand what you are telling me to do.

Excuse me for being ignorant abouit it, its why I am asking for help,
coz I dont know.

I didnt even know an "immediate" window existed until a very recent
post of yours when you told me how to get to it so how could I have
posted all this stuff to the immediate window.

Also, I just posted to you, telling you where things are and I only
have one thing in immediate window in that post dont i?

Look, dont worry about it, its not life or death that I get this done,
I will just do without it.

And I resent your ciomment "Why would assume that when you were given
specific instructions to the contrary?", it was uncalled for. Dont
make people out to be dumb.

Esra




On Fri, 15 Feb 2008 13:21:44 -0800, Gord Dibben <gorddibbATshawDOTca
wrote:

Esra

Why would assume that when you were given specific instructions to the contrary?

Quoted directly from my second post........................

a) Copy these two macros to a general code module:
=================

Option Private Module
Public Sequence As Date
Sub StartBlinking()
Sequence = Now + TimeSerial(0, 0, 1)
Worksheets("MySheet").Range("B1").Calculate
Application.OnTime Sequence, "StartBlinking"
End Sub

Sub StopBlinking()
On Error Resume Next
Application.OnTime Sequence, "StartBlinking", Schedule:=False
End Sub

===================

b) Copy these two events to 'ThisWorkbook' code module:
===================

Private Sub Workbook_Open()
StartBlinking
End Sub

Private Sub Workbook_BeforeClose(Cancel As Boolean)
StopBlinking
End Sub

End quote..................................

And the other instructions I gave was for you enter

Aplication.EnableEvents = True into the Immediate window.

Sounds like you placed your workbook_open code into the Immediate window.



Gord Dibben MS Excel MVP



On Sat, 16 Feb 2008 09:34:58 +1300, Esra Dekan wrote:

OK, (my mistake, I just assumed it went there)
that stops the compile error thing coming up and seems to be ok,
but text still doesnt blink in the requested cell.

Any ideas?

Esra


On Fri, 15 Feb 2008 10:47:53 -0600, Dave Peterson
wrote:

Under Sheet1 "General"

Isn't right.

If the code is behind a worksheet, then it's not in the right place.

Select your project in the VBE
Insert|Module
Paste the code in that newly opened window.
Delete the code from behind Sheet1.

Esra Dekan wrote:

Under ThisWorkbook

Private Sub Workbook_Open()
StartBlinking
End Sub

Private Sub Workbook_BeforeClose(Cancel As Boolean)
StopBlinking
End Sub

Under Sheet1 "General"

Sub StartBlinking()
Sequence = Now + TimeSerial(0, 0, 1)
Worksheets("Sheet1").Range("x8").Calculate
Application.OnTime Sequence, "StartBlinking"
End Sub

Sub StopBlinking()
On Error Resume Next
Application.OnTime Sequence, "StartBlinking", Schedule:=False
End Sub

This in "immediate" window now

Application.EnableEvents = True

No other macros in workbook

HTH
Esra

On Thu, 14 Feb 2008 18:51:09 -0600, Dave Peterson
wrote:

It's time to post your macros.

What's Under the ThisWorkbook module?

What's under each (and every) general module?

Esra Dekan wrote:

Well, that doesnt work either.

I put it in there, then saved it, opened it up again, and it opened
the VBA with this error:

Compile Error:

Sub or Function not defined

Referring to this:

Private Sub Workbook_Open()
StartBlinking
End Sub

When I click off that error message, I check to see if the "immediate"
still contains that command, and although I saved it, it does not.

So, I put it back in, save again, and close the VBA and then save and
close the file, and get this message:

Compile Error:

Sub or Function not defined

Referring to this:

Private Sub Workbook_BeforeClose(Cancel As Boolean)
StopBlinking
End Sub

So, got me stumped.
I just wont have the text blinking. It would of been nice, but not
going to all this trouble for that effect.

TY for all your help everyone.

Esra

On Thu, 14 Feb 2008 15:59:00 -0600, Dave Peterson
wrote:

Open the VBE and hit ctrl-g (or view|Immediate window)

Esra Dekan wrote:

Now I am even more confused. Im so dumb when it comes to a lot of
things in Excel.

Where is the "immediate" window in VBE?

Esra

On Thu, 07 Feb 2008 20:37:39 -0800, Gord Dibben <gorddibbATshawDOTca
wrote:

Other than send you another working copy of a workbook, I see nothing else to
help you.

Well........maybe try opening the Immediate Window from VBE and copy this in and
hit ENTER

Application.EnableEvents = True


Gord

On Fri, 08 Feb 2008 15:01:24 +1300, Esra Dekan wrote:

Yes, happens in the workbook you sent, and cell b1 is just green with
text in, not blinking.

All i get in MY workbook here, is the compile error thing. I dont
know enough to know what that even means.

The Private sub thing, I right clicked "this Workbook",,,and inserted
a module, pasted the Private Sub into there.

It must be something with my excelt surely, coz it happens on the book
you sent me,,,maybe?

:((

TIA

Esra



On Thu, 07 Feb 2008 10:06:54 -0800, Gord Dibben <gorddibbATshawDOTca
wrote:

Does this occur in the workbook I sent you?

If so, have you changed anything at all?

Was working fine when I emailed the workbook to you.

"asdfg" in B1 was blinking a green color.

I still have the original if you want it re-sent.


Gord Dibben MS Excel MVP

On Thu, 07 Feb 2008 19:26:44 +1300, Esra Dekan wrote:

Still not working,

When I open the file, it comes up saying "Compile Error. Sub or
Function Not Defined"

and goes to this macro

Private Sub Workbook_Open()
StartBlinking
End Sub

When closing does the same too, goes to the macro StopBlinking


Any help??

Esra




On Sun, 03 Feb 2008 11:46:17 -0800, Gord Dibben <gorddibbATshawDOTca
wrote:

Worked fine before I sent it to you.

Did you get a message about enabling macros when you opened the workbook I sent?

If not, your macro security is set too high and Excel automatically prevents
code from running and puts the workbook in the HelpAbout MS ExcelDisabled
Items.

Have a look there first and re-enable it then reset your security level.

ToolsOptionsSecurityMacro Security.

Set it to "Medium", OK out, then close out Excel and re-open.

Enable macros when you get the message about workbook contains macros.


Gord

On Mon, 04 Feb 2008 07:38:58 +1300, Esra Dekan wrote:

That doesnt work here either.

maybe something wrong with the program? Do I need an add=in or
something?


Esra


On Sat, 02 Feb 2008 20:10:42 -0800, Gord Dibben <gorddibbATshawDOTca
wrote:

Have sent one to you.


Gord

On Sun, 03 Feb 2008 16:18:45 +1300, Esra Dekan wrote:

Maybe by chance, could someone email me a workbook with a flashing
cell? and I should be able to work it out from there.

I just cant seem to get it for some reason.

My email address is in the message i think, minus the underscore.

I wouls appreciate it

Esra



  #31   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 22,906
Default Blinking Text

I suggest whatever stops B1 blinking green/no color in my workbook is at your
end.

Just wish I knew what.

You sure you have security set to medium so's you get the macro warning when you
open the workbook?

Blinks fine at my end.

Can you send it back to me if you're not too ****ed off with the entire exercise
and me?


Gord

On Sun, 17 Feb 2008 13:27:41 +1300, Esra Dekan wrote:

Oh and its also worth pointing out, that the workbook you sent me that
is supposed to have blinking in it, has all the commands in exactly
the same places as I do in my workbook, and it TOO doesnt work.

I suggest something might have been overlooked.

Esra



On Sat, 16 Feb 2008 14:12:40 -0800, Gord Dibben <gorddibbATshawDOTca
wrote:

The only thing I asked you to put in the Immediate window in the workbook I sent
to you was

Application.EnableEvents = True

The reason for that was to make sure events were enabled.

If you do that, close the workbook and re-open the green text should blink.

My comment was not intended to make you out to be dumb.......dumb is your word,
not mine.

It was intended only to prod you to read things a little more closely when you
are given instructions.

You and anyone else using the workbook are much better off without the annoyance
of blinking text, so abandoning the idea is a good decision.

Apologies for upsetting you.

I guess my people-skills are drifting away with the other wearing-out parts.


Gord



On Sun, 17 Feb 2008 10:17:12 +1300, Esra Dekan wrote:

If I didnt post things in the right location thnen it is purely
because I didnt understand what you are telling me to do.

Excuse me for being ignorant abouit it, its why I am asking for help,
coz I dont know.

I didnt even know an "immediate" window existed until a very recent
post of yours when you told me how to get to it so how could I have
posted all this stuff to the immediate window.

Also, I just posted to you, telling you where things are and I only
have one thing in immediate window in that post dont i?

Look, dont worry about it, its not life or death that I get this done,
I will just do without it.

And I resent your ciomment "Why would assume that when you were given
specific instructions to the contrary?", it was uncalled for. Dont
make people out to be dumb.

Esra




On Fri, 15 Feb 2008 13:21:44 -0800, Gord Dibben <gorddibbATshawDOTca
wrote:

Esra

Why would assume that when you were given specific instructions to the contrary?

Quoted directly from my second post........................

a) Copy these two macros to a general code module:
=================

Option Private Module
Public Sequence As Date
Sub StartBlinking()
Sequence = Now + TimeSerial(0, 0, 1)
Worksheets("MySheet").Range("B1").Calculate
Application.OnTime Sequence, "StartBlinking"
End Sub

Sub StopBlinking()
On Error Resume Next
Application.OnTime Sequence, "StartBlinking", Schedule:=False
End Sub

===================

b) Copy these two events to 'ThisWorkbook' code module:
===================

Private Sub Workbook_Open()
StartBlinking
End Sub

Private Sub Workbook_BeforeClose(Cancel As Boolean)
StopBlinking
End Sub

End quote..................................

And the other instructions I gave was for you enter

Aplication.EnableEvents = True into the Immediate window.

Sounds like you placed your workbook_open code into the Immediate window.



Gord Dibben MS Excel MVP



On Sat, 16 Feb 2008 09:34:58 +1300, Esra Dekan wrote:

OK, (my mistake, I just assumed it went there)
that stops the compile error thing coming up and seems to be ok,
but text still doesnt blink in the requested cell.

Any ideas?

Esra


On Fri, 15 Feb 2008 10:47:53 -0600, Dave Peterson
wrote:

Under Sheet1 "General"

Isn't right.

If the code is behind a worksheet, then it's not in the right place.

Select your project in the VBE
Insert|Module
Paste the code in that newly opened window.
Delete the code from behind Sheet1.

Esra Dekan wrote:

Under ThisWorkbook

Private Sub Workbook_Open()
StartBlinking
End Sub

Private Sub Workbook_BeforeClose(Cancel As Boolean)
StopBlinking
End Sub

Under Sheet1 "General"

Sub StartBlinking()
Sequence = Now + TimeSerial(0, 0, 1)
Worksheets("Sheet1").Range("x8").Calculate
Application.OnTime Sequence, "StartBlinking"
End Sub

Sub StopBlinking()
On Error Resume Next
Application.OnTime Sequence, "StartBlinking", Schedule:=False
End Sub

This in "immediate" window now

Application.EnableEvents = True

No other macros in workbook

HTH
Esra

On Thu, 14 Feb 2008 18:51:09 -0600, Dave Peterson
wrote:

It's time to post your macros.

What's Under the ThisWorkbook module?

What's under each (and every) general module?

Esra Dekan wrote:

Well, that doesnt work either.

I put it in there, then saved it, opened it up again, and it opened
the VBA with this error:

Compile Error:

Sub or Function not defined

Referring to this:

Private Sub Workbook_Open()
StartBlinking
End Sub

When I click off that error message, I check to see if the "immediate"
still contains that command, and although I saved it, it does not.

So, I put it back in, save again, and close the VBA and then save and
close the file, and get this message:

Compile Error:

Sub or Function not defined

Referring to this:

Private Sub Workbook_BeforeClose(Cancel As Boolean)
StopBlinking
End Sub

So, got me stumped.
I just wont have the text blinking. It would of been nice, but not
going to all this trouble for that effect.

TY for all your help everyone.

Esra

On Thu, 14 Feb 2008 15:59:00 -0600, Dave Peterson
wrote:

Open the VBE and hit ctrl-g (or view|Immediate window)

Esra Dekan wrote:

Now I am even more confused. Im so dumb when it comes to a lot of
things in Excel.

Where is the "immediate" window in VBE?

Esra

On Thu, 07 Feb 2008 20:37:39 -0800, Gord Dibben <gorddibbATshawDOTca
wrote:

Other than send you another working copy of a workbook, I see nothing else to
help you.

Well........maybe try opening the Immediate Window from VBE and copy this in and
hit ENTER

Application.EnableEvents = True


Gord

On Fri, 08 Feb 2008 15:01:24 +1300, Esra Dekan wrote:

Yes, happens in the workbook you sent, and cell b1 is just green with
text in, not blinking.

All i get in MY workbook here, is the compile error thing. I dont
know enough to know what that even means.

The Private sub thing, I right clicked "this Workbook",,,and inserted
a module, pasted the Private Sub into there.

It must be something with my excelt surely, coz it happens on the book
you sent me,,,maybe?

:((

TIA

Esra



On Thu, 07 Feb 2008 10:06:54 -0800, Gord Dibben <gorddibbATshawDOTca
wrote:

Does this occur in the workbook I sent you?

If so, have you changed anything at all?

Was working fine when I emailed the workbook to you.

"asdfg" in B1 was blinking a green color.

I still have the original if you want it re-sent.


Gord Dibben MS Excel MVP

On Thu, 07 Feb 2008 19:26:44 +1300, Esra Dekan wrote:

Still not working,

When I open the file, it comes up saying "Compile Error. Sub or
Function Not Defined"

and goes to this macro

Private Sub Workbook_Open()
StartBlinking
End Sub

When closing does the same too, goes to the macro StopBlinking


Any help??

Esra




On Sun, 03 Feb 2008 11:46:17 -0800, Gord Dibben <gorddibbATshawDOTca
wrote:

Worked fine before I sent it to you.

Did you get a message about enabling macros when you opened the workbook I sent?

If not, your macro security is set too high and Excel automatically prevents
code from running and puts the workbook in the HelpAbout MS ExcelDisabled
Items.

Have a look there first and re-enable it then reset your security level.

ToolsOptionsSecurityMacro Security.

Set it to "Medium", OK out, then close out Excel and re-open.

Enable macros when you get the message about workbook contains macros.


Gord

On Mon, 04 Feb 2008 07:38:58 +1300, Esra Dekan wrote:

That doesnt work here either.

maybe something wrong with the program? Do I need an add=in or
something?


Esra


On Sat, 02 Feb 2008 20:10:42 -0800, Gord Dibben <gorddibbATshawDOTca
wrote:

Have sent one to you.


Gord

On Sun, 03 Feb 2008 16:18:45 +1300, Esra Dekan wrote:

Maybe by chance, could someone email me a workbook with a flashing
cell? and I should be able to work it out from there.

I just cant seem to get it for some reason.

My email address is in the message i think, minus the underscore.

I wouls appreciate it

Esra


  #32   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 22,906
Default Blinking Text

I will post the file to net site and if anyone wants to test it please do so.

We have to get Esra blinking.

http://www.savefile.com/files/1384975


Gord

On Sat, 16 Feb 2008 17:08:25 -0800, Gord Dibben <gorddibbATshawDOTca wrote:

I suggest whatever stops B1 blinking green/no color in my workbook is at your
end.

Just wish I knew what.

You sure you have security set to medium so's you get the macro warning when you
open the workbook?

Blinks fine at my end.

Can you send it back to me if you're not too ****ed off with the entire exercise
and me?


Gord


  #33   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 35,218
Default Blinking Text

I downloaded the file and saved it to my desktop.

I opened it in xl2003 (enabling macros) and it worked fine. B1 blinked a fill
color of green.

Gord Dibben wrote:

I will post the file to net site and if anyone wants to test it please do so.

We have to get Esra blinking.

http://www.savefile.com/files/1384975

Gord

On Sat, 16 Feb 2008 17:08:25 -0800, Gord Dibben <gorddibbATshawDOTca wrote:

I suggest whatever stops B1 blinking green/no color in my workbook is at your
end.

Just wish I knew what.

You sure you have security set to medium so's you get the macro warning when you
open the workbook?

Blinks fine at my end.

Can you send it back to me if you're not too ****ed off with the entire exercise
and me?


Gord


--

Dave Peterson
  #34   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 22,906
Default Blinking Text

Thanks for checking Dave.

I just tested with calculation set to manual and no blinking.

Back to auto and resumed blinking.

Would appear that Esra's calc mode has been set to manual.....maybe by opening
another workbook first with calc at manual.


Gord

On Sat, 16 Feb 2008 20:29:05 -0600, Dave Peterson
wrote:

I downloaded the file and saved it to my desktop.

I opened it in xl2003 (enabling macros) and it worked fine. B1 blinked a fill
color of green.

Gord Dibben wrote:

I will post the file to net site and if anyone wants to test it please do so.

We have to get Esra blinking.

http://www.savefile.com/files/1384975

Gord

On Sat, 16 Feb 2008 17:08:25 -0800, Gord Dibben <gorddibbATshawDOTca wrote:

I suggest whatever stops B1 blinking green/no color in my workbook is at your
end.

Just wish I knew what.

You sure you have security set to medium so's you get the macro warning when you
open the workbook?

Blinks fine at my end.

Can you send it back to me if you're not too ****ed off with the entire exercise
and me?


Gord


  #35   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 22
Default Blinking Text

Dont see what good that will do. Obviously it works for you, but it
doesnt work here. It may be somethign I have wrong in my Excel, I
dont know. I have enabled all macros on security and have set it to
the lowest level. I dont know what more I can do.

Esra


On Sat, 16 Feb 2008 17:19:02 -0800, Gord Dibben <gorddibbATshawDOTca
wrote:

I will post the file to net site and if anyone wants to test it please do so.

We have to get Esra blinking.

http://www.savefile.com/files/1384975


Gord

On Sat, 16 Feb 2008 17:08:25 -0800, Gord Dibben <gorddibbATshawDOTca wrote:

I suggest whatever stops B1 blinking green/no color in my workbook is at your
end.

Just wish I knew what.

You sure you have security set to medium so's you get the macro warning when you
open the workbook?

Blinks fine at my end.

Can you send it back to me if you're not too ****ed off with the entire exercise
and me?


Gord



  #36   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 22,906
Default Blinking Text

Esra

See my reply to Dave about calculation mode.

To ensure that calc mode is always on automatic when the workbook is opened,
change/add one line to the workbook_open code.

Private Sub Workbook_Open()
Application.Calculation = xlCalculationAutomatic 'add this line
StartBlinking
End Sub

Save and close then re-open.


Gord

On Sun, 17 Feb 2008 16:14:07 +1300, Esra Dekan wrote:

Dont see what good that will do. Obviously it works for you, but it
doesnt work here. It may be somethign I have wrong in my Excel, I
dont know. I have enabled all macros on security and have set it to
the lowest level. I dont know what more I can do.

Esra


On Sat, 16 Feb 2008 17:19:02 -0800, Gord Dibben <gorddibbATshawDOTca
wrote:

I will post the file to net site and if anyone wants to test it please do so.

We have to get Esra blinking.

http://www.savefile.com/files/1384975


Gord

On Sat, 16 Feb 2008 17:08:25 -0800, Gord Dibben <gorddibbATshawDOTca wrote:

I suggest whatever stops B1 blinking green/no color in my workbook is at your
end.

Just wish I knew what.

You sure you have security set to medium so's you get the macro warning when you
open the workbook?

Blinks fine at my end.

Can you send it back to me if you're not too ****ed off with the entire exercise
and me?


Gord


  #37   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 454
Default Blinking Text

Worked for me first time, running Xl 2000

  #38   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 35,218
Default Blinking Text

It shows that the code works. And there is something wrong with what you're
doing.

I don't have any guesses at what that is.

Esra Dekan wrote:

Dont see what good that will do. Obviously it works for you, but it
doesnt work here. It may be somethign I have wrong in my Excel, I
dont know. I have enabled all macros on security and have set it to
the lowest level. I dont know what more I can do.

Esra

On Sat, 16 Feb 2008 17:19:02 -0800, Gord Dibben <gorddibbATshawDOTca
wrote:

I will post the file to net site and if anyone wants to test it please do so.

We have to get Esra blinking.

http://www.savefile.com/files/1384975


Gord

On Sat, 16 Feb 2008 17:08:25 -0800, Gord Dibben <gorddibbATshawDOTca wrote:

I suggest whatever stops B1 blinking green/no color in my workbook is at your
end.

Just wish I knew what.

You sure you have security set to medium so's you get the macro warning when you
open the workbook?

Blinks fine at my end.

Can you send it back to me if you're not too ****ed off with the entire exercise
and me?


Gord


--

Dave Peterson
  #39   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 22
Default Blinking Text

My calculation mode is set to Auto

Esra



, Gord Dibben <gorddibbATshawDOTca wrote:

Thanks for checking Dave.

I just tested with calculation set to manual and no blinking.

Back to auto and resumed blinking.

Would appear that Esra's calc mode has been set to manual.....maybe by opening
another workbook first with calc at manual.


Gord

On Sat, 16 Feb 2008 20:29:05 -0600, Dave Peterson
wrote:

I downloaded the file and saved it to my desktop.

I opened it in xl2003 (enabling macros) and it worked fine. B1 blinked a fill
color of green.

Gord Dibben wrote:

I will post the file to net site and if anyone wants to test it please do so.

We have to get Esra blinking.

http://www.savefile.com/files/1384975

Gord

On Sat, 16 Feb 2008 17:08:25 -0800, Gord Dibben <gorddibbATshawDOTca wrote:

I suggest whatever stops B1 blinking green/no color in my workbook is at your
end.

Just wish I knew what.

You sure you have security set to medium so's you get the macro warning when you
open the workbook?

Blinks fine at my end.

Can you send it back to me if you're not too ****ed off with the entire exercise
and me?


Gord

  #40   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 22
Default Blinking Text - compile.jpg (0/1)

OK,here is a screenshot of what is happening.

I have added the line as you suggested (as you will see), my
calculations are set to auto. Its still doing the same thing.

Esra


On Sat, 16 Feb 2008 19:23:47 -0800, Gord Dibben <gorddibbATshawDOTca
wrote:

Esra

See my reply to Dave about calculation mode.

To ensure that calc mode is always on automatic when the workbook is opened,
change/add one line to the workbook_open code.

Private Sub Workbook_Open()
Application.Calculation = xlCalculationAutomatic 'add this line
StartBlinking
End Sub

Save and close then re-open.


Gord

On Sun, 17 Feb 2008 16:14:07 +1300, Esra Dekan wrote:

Dont see what good that will do. Obviously it works for you, but it
doesnt work here. It may be somethign I have wrong in my Excel, I
dont know. I have enabled all macros on security and have set it to
the lowest level. I dont know what more I can do.

Esra


On Sat, 16 Feb 2008 17:19:02 -0800, Gord Dibben <gorddibbATshawDOTca
wrote:

I will post the file to net site and if anyone wants to test it please do so.

We have to get Esra blinking.

http://www.savefile.com/files/1384975


Gord

On Sat, 16 Feb 2008 17:08:25 -0800, Gord Dibben <gorddibbATshawDOTca wrote:

I suggest whatever stops B1 blinking green/no color in my workbook is at your
end.

Just wish I knew what.

You sure you have security set to medium so's you get the macro warning when you
open the workbook?

Blinks fine at my end.

Can you send it back to me if you're not too ****ed off with the entire exercise
and me?


Gord

Reply
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
how to make Blinking Background on text or cell? Jon Excel Discussion (Misc queries) 4 November 2nd 07 11:30 AM
Can we add a blinking text / figure in spreadsheet. Sam Excel Worksheet Functions 2 January 11th 07 02:48 PM
how do I add flashing text or blinking text in Excel? Paula Brennan Excel Discussion (Misc queries) 1 October 31st 06 08:27 AM
CAN TEXT EFFECTS BE USED IN EXCEL E,G, BLINKING BACKGROUND CliveA Excel Discussion (Misc queries) 1 July 28th 06 04:33 PM
Can we insert blinking text in MS Excel ? Terranger Excel Discussion (Misc queries) 2 July 4th 06 05:00 PM


All times are GMT +1. The time now is 01:43 PM.

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

About Us

"It's about Microsoft Excel"