A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Worksheet Functions
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Blinking Text



 
 
Thread Tools Display Modes
  #41  
Old February 17th, 2008, 08:39 PM posted to microsoft.public.excel.worksheet.functions
Esra Dekan
external usenet poster
 
Posts: 22
Default Blinking Text - compile.jpg (1/1)



  #42  
Old February 17th, 2008, 09:08 PM posted to microsoft.public.excel.worksheet.functions
Gord Dibben
external usenet poster
 
Posts: 20,252
Default Blinking Text - compile.jpg (0/1)

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


  #43  
Old February 18th, 2008, 11:58 PM posted to microsoft.public.excel.worksheet.functions
Esra Dekan
external usenet poster
 
Posts: 22
Default Blinking Text - compile.jpg (0/1)

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

  #44  
Old February 19th, 2008, 01:42 AM posted to microsoft.public.excel.worksheet.functions
Gord Dibben
external usenet poster
 
Posts: 20,252
Default Blinking Text - compile.jpg (0/1)

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


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 11:11 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.