From that error message it would seem that the StartBlinking macro is not to be
found.

The workbook I sent to you and the savefile download contains the proper code in
the proper locations.

Would you please send me by email a copy of the workbook Wellington7s

First save the copy as 97-2003 format.

I don't have 2007 and not inclined to load the compatibility pack right now.


Gord

On Mon, 18 Feb 2008 08:39:19 +1300, Esra Dekan wrote:

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

Thank you so much Gord, yes it was my stupidity. I appreciate your
efforts in solving it. Now, I just need to find a 'head' clinic to
sort out the rest of my stupidity.

Esra



On Sun, 17 Feb 2008 12:08:49 -0800, Gord Dibben <gorddibbATshawDOTca
wrote:

From that error message it would seem that the StartBlinking macro is not to be
found.

The workbook I sent to you and the savefile download contains the proper code in
the proper locations.

Would you please send me by email a copy of the workbook Wellington7s

First save the copy as 97-2003 format.

I don't have 2007 and not inclined to load the compatibility pack right now.


Gord

On Mon, 18 Feb 2008 08:39:19 +1300, Esra Dekan wrote:

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

Delighted that you received my revised edition of Wellington 7s.xls with all its
revisions intact.

Just keep plugging away and remember to read carefully when receiving
instructions.

A habit more of us could benefit from, I might add.

Google for my posts and you will find quite a few that say "Oops, guess I
should read the whole post"


Gord


On Tue, 19 Feb 2008 11:58:06 +1300, Esra Dekan wrote:

Thank you so much Gord, yes it was my stupidity. I appreciate your
efforts in solving it. Now, I just need to find a 'head' clinic to
sort out the rest of my stupidity.

Esra



On Sun, 17 Feb 2008 12:08:49 -0800, Gord Dibben <gorddibbATshawDOTca
wrote:

From that error message it would seem that the StartBlinking macro is not to be
found.

The workbook I sent to you and the savefile download contains the proper code in
the proper locations.

Would you please send me by email a copy of the workbook Wellington7s

First save the copy as 97-2003 format.

I don't have 2007 and not inclined to load the compatibility pack right now.


Gord

On Mon, 18 Feb 2008 08:39:19 +1300, Esra Dekan wrote:

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