Programming

macro to run when I hide or unhide rows in a group
I need to keep a spreadsheet in manual recalc mode but would like it to automatically recalc when rows in a group are hidden or unhidden. ... 27 Mar 2010 09:40

Excel 2007 data query parameter issue
*** Sent via Developersdex http://www.developersdex.com *** ... 27 Mar 2010 04:26

Macro
Cell A1 = blank Cell A2 is … =CONCATENATE(RIGHT(YEAR(NOW()),2),TEXT(MONTH(NOW()),”00”),TEXT(DAY(NOW()),”00”),TEXT(HOUR(NOW()),”00”),TEXT(MINUTE(NOW()),”00”),TEXT(SECOND(NOW()),”00”)) (results in yymmddhhmmss) I need a macro or something that when A1 = blank, then I want the resulting value from A2 to be put in... 27 Mar 2010 03:21

DoneEx XCell Compiler - comments on VBA protection?
Can anyone comment on the VBA protection of DoneEx XCell Compiler? I asked DoneEx and they say they just hide the VBA code from view; they don't compile it to binary. Any thoughts on how much risk there is that someone could hack the protection and view my code? http://doneex.com/index.php?option=com_content&ta... 27 Mar 2010 12:00

Showing argument descriptions as an XLL worksheet function is type
Hi, Apologies if this is wrong newsgroup, I wasn't sure if this or microsoft.public.excel.sdk is better. We're developing a set of XLL worksheet functions that have 5-8 difficult to remember arguments. While the argument descriptions passed to the registration function display properly in the function wi... 27 Mar 2010 05:34

How to skip the confirmation on updating link?
for updating links, under Edit > Links, I have specify that Excel always update links, and save it, when I open it next time, message box is still pop up for confirmation. Do you have any suggestions on how to skip the confirmation on updating links? Thanks in advance for any suggestions Eric ... 27 Mar 2010 08:14

Collect value
I have 4 cells: H8 I8 J8 K8 If change H8, I8 J8 K8 cells have variable value. I want to change values of H8 from 10 to 150 and collect all 4 cells value in columns AF AG AH AI. Please help me with same VBA code. Thanks. ... 27 Mar 2010 00:02

Complex If/Or/And formula
I am working on a formula that has me frazzled. I can't get seem to get the correct result for all of my scenarios. Column G is Planned End Date Column H is Revised End Date This is what I have so far; =OR(ISBLANK(G3),(WORKDAY(NOW(),0)-WORKDAY(G3,0)<7),OR((WORKDAY(H3,0)<WORKDAY(NOW(),0)),ISBLANK(H3))) I a... 27 Mar 2010 18:51

Excel VBA recommendations
Hello I'll be jumping into writing up some excel Marcos for some of our office bean counters. Any recommendations were to get or download some tutorial to me started? I've looked at Google, but thats only gets me bits and pieces with allot of searching on my part. I'm already familiar with developing VB s... 27 Mar 2010 13:09

Redirecting ALT+1 keystrokes to run routine
In an Excel 2007 Workbook I'd like to redirect or capture the ALT+1, ALT+2, ALT+3, etc. key stroke combinations to run some navigation routines I've written. I've tried using the following in the Workbook.Open event. Application.OnKey "%{1}", "sNavigateToGroup1" Application.OnKey "%{2}", "sNavigateToGr... 26 Mar 2010 19:16