I add this page to my site yesterday
Menu for favorite macros in Excel 2007      
http://www.rondebruin.nl/qat.htm
Because it is not so easy to change the Ribbon I think this is a good option to create a menu

I have a sheet, in which i have to lock a single cell. i used the
following code:
ActiveSheet.Range("$J$29:$K$29").Select
   Range("$J$29:$K$29").Select

I have a textbox on a user form that is giving me an error when a
number is entered in.  This number is a percent and the code for the
textbox is:
Private Sub TextBox35_AfterUpdate()

I am trying to do the following.
First I must check the value of several cells in one worksheet lets say a2,
a3, b2 c5. then checking for empty rows in the next worksheet push the value
of the cells to different cells in the second worksheet writing them on the

I have a macro that I want to run on all sheets except the first one.
Can I just put all the code in 'ThisWorkbook' and somehow tell it to
exclude the first sheet?
Thanks,

I'm trying to add a control to a worksheet and then modify its
parameters.  To learn how to do this I have the following code:
Option Explicit
Public Sub InsertChkBx1()

Need to list the individual frquencies for each Number
i.e.
Number    Frequency
1              10

I'm trying to set up a macro to save the selected print area as a single
file web page, but I get an error at .Publish (True) "Runtime error 1004
Application-defined or object-defined error."
Private Sub cmdSave_Click()

I have a workbook that invokes the Workbook_BeforeClose sub routine when
shutting down. I would like to change the behavior of this routine dependant
upon whether the closing of the workbook is associated with the shutting
down of Excel (version 2003).

fairly straight forward one here.
Can I create a nested Dictionary structure, that is, store and retrieve
Objects of type Dictionary within another Object of type Dictionary??
Also, I would be greatfull if someone could tell me where on MSDN i can

i have created list box dynamically in the sheet in each row.
now i wnat that rather then coding for each event of the list box, i
shd be able to handle one event for each list box...
is it possible ?

what would the 2 formulas be to alternate cell colors in the date groups?
1/2/2007
1/2/2007
1/2/2007

Is there a formula that will count the number of characters, and spaces
between characters, in a short paragraph created by a string text?  It
is acceptible if spaces cannot be counted.  Thanks.
Michael

Hi, when I import external data into excel using the Tools > Import
External Data > .... function where does excel store this connection?
I know it's there because i can right click and 'Refresh Data".....
I would like to access this connection some how but am not sure as how

I want to have  a user click a Commandbutton on Userform5 that will Show
Userform8.
This is OK,
Userform8 has a CommandButton1 to View a Sheet in PrintPreview.