Thread: Blinking Text
View Single Post
  #40   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Esra Dekan Esra Dekan is offline
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