Posts by Iridium

    Try using the macro recorder to generate the necessary code. I tried it and got the following (not using your example exactly):

    With ActiveSheet.PageSetup
         .LeftFooter = "&""Arial Black,Bold""&10hello"
    End With


    The newly added sheet will then be active so perhaps try something like this:

    Sub Test()
    Worksheets.Add ' Add a worksheet
    ActiveSheet.Name = "test" ' Name a worksheet.
    End Sub


    Haven't tested this btw but give it a go:


    I'm no guru - the macro was filched from the microsoft knowledge base!

    If you mean how do you run the macro then whilst in xl hit Alt+F11. On the left hand side you should see the project explorer window (if not hit Ctrl+R). You should see your workbook listed as VBAProject (yourworkbook name) - right-click on it and choose insert module. Paste the code into this. If you flip back to xl the macros can be run from Tools>Macro>Macros

    That what you mean?

    Not sure but try this macro:


    I'm talking out of my arse! You're right that you can't change the formatting! oops!

    Erm... What formats do you want to apply? Just wondering if there's something you could do with a macro using the unprotect/reprotect method perhaps?


    Originally posted by BigWorm
    Hi Guys

    I have an Excel sheet with a column of numbers, the cost of my items. example rows A1 to A400 have the value of my stock in them, I would like to add the numbers together, and come out with a total value of my stock.

    Big Worm

    Might have missed your point (brain not working) but do you need the SUM function???

    Edit: like A401=SUM(A1:A400) ?

    Just re-read your original post - you know that you can format individual cells as unlocked (Format>Cells... Protection tab, unchecking the locked option) before you protect the sheet? Ergo keep your cells with formulae in locked and format the cells you want to be able to change as unlocked.

    That what you mean?

    This what you mean? From the (xl2k2) help file:

    Control the startup prompt for updating links
    Don't ask whether to update links when I open any workbook, and update links automatically

    This option is for the current user only, and affects every workbook opened. Other users of the workbook are not affected. This option also affects links to other programs.

    On the Tools menu, click Options, and then click the Edit tab.
    Clear the Ask to update automatic links check box. If the box is cleared, the links are automatically updated, and no prompt is displayed.
    Don't ask to update links for this workbook, and let me control whether links are updated

    Warning This option affects all users of the workbook. If you choose to not update links, and not to prompt, users of the workbook will not know the data is out of date.

    On Edit menu, click Links.
    Click Startup Prompt.
    Select the option you want.
    Note You will still be notified if there are any broken links.