Programming

How to access macros via tool buttons?
Excel v2007 When using v2003, I had many macros In my Personal.xls, which I accessed via custom tool buttons on many custom toolbars that I built. I now have version 2007, which includes my old Personal.xls with all my macros, but I want the easy access to those macros I used to have. Being the tool ribbon is a ... 27 May 2010 11:31

Oh, I forgot to say...
Obviously you'll need to scan it first! "Ron" <whasupwityou(a)gmail.com> wrote in message news:0aa97473-da42-4f66-bee2-801b84860f0e(a)g1g2000pro.googlegroups.com... Hello all, I have hard copies of Excel data, I do not have a soft copy. Is there a way to convert my paper (hard copies) to digital format so ... 27 May 2010 12:38

VBA to insert .xlborder if cell value not equal to previous cell
I've got a worksheet and I'm wondering whether it is possible to insert a line when a value in Column A, B, C & D does not equal the values in the row above or below it. I've currently got a formula in Column A that reads.... =IF(AND(B3=B2,C3=C2,D3=D2,E3=E2),"","IL") and a conditional format that if the cell val... 27 May 2010 04:54

Fix Broken Cell Formula with VBA
Greetings, I have a cell formula that is damaged each time I run a delete to remove excess rows before a paste & copy. this formula links to a cell that is always deleted. So I am trying to repair this formula at the end of each cycle. Here is the correct formula: =IF(A11="Proximates","Click","") Her... 27 May 2010 02:46

To show a message box if the mouse is over a particular cell??
Is there a particular way to display a message box,(or run any other sub) if the user puts the mouse over it lets say for cell A1. Like it display comments for cells that have comments in them. Since, there is a property of in excel to response to mousehover, I expect that this can be done. ... 26 May 2010 20:18

Cosmetics
My applet is complete. It works and all the data gets formatted correctly. Thanks to all of you that helped me through this. However, it's not all that pretty.... I'm getting "Not Responding" messages, Blue screen, screen flashing, etc. My progress bar doesn't want to stay on top, and it takes 4 minutes to ru... 26 May 2010 22:28

Conditional formatting if condition of an if statement is true and astring value is displayed
Let's say your doing this conditional formatting in cell K17. In conditional formatting (xl2003) choose the FormulaIs: option and enter: =$K$17<>"" choose your formatting and OK. In xl2007, choose NewRule..., then 'Use a formula to determine which cells to format' and in the 'Format values where this formula is ... 26 May 2010 18:04

Reading system log files
Does anyone know how to read Windows 7 System log files? I need to extract records from System and Application logs and insert them into a list of other events. The insert part is easy - append then sort by date_time. However, I cannot find anything that gives me any help to read the logs. Perhaps the other lim... 2 Jun 2010 05:29

Icon in Notification area
Hi everybody, Does someone know how to put my Excel VBA application icon (2003 ~ 2007) in the notification area? I ask because my program hides Excel screen during execution. Application.Visible = false Thank you for your interest in my problem. Pierre ... 27 May 2010 18:11

Icon in Notification zone
Hi everybody, Does someone know how to put my Excel VBA application icon (2003 ~ 2007) in the notification area? I ask because my program hides Excel screen during execution. Application.Visible = false Thank you for your interest in my problem. Pierre ... 26 May 2010 15:50