Home |
Search |
Today's Posts |
#41
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Blinking Text - compile.jpg (1/1)
|
#42
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to make Blinking Background on text or cell? | Excel Discussion (Misc queries) | |||
Can we add a blinking text / figure in spreadsheet. | Excel Worksheet Functions | |||
how do I add flashing text or blinking text in Excel? | Excel Discussion (Misc queries) | |||
CAN TEXT EFFECTS BE USED IN EXCEL E,G, BLINKING BACKGROUND | Excel Discussion (Misc queries) | |||
Can we insert blinking text in MS Excel ? | Excel Discussion (Misc queries) |