Posts by royUK

    I wouldn't use such a control. If you want to slect a file use this


    That's Common Dialog Class, I think you want the Common Dialog Control. I think this control is like the DatePicker control and is not always available.


    Also, I think if you are running a 64-bit version then it will not be available

    1. Select all the cells you don't want to be locked. These will be the specific cells that can be edited even after the sheet is protected.
    2. Right-click on your selection, select Format Cells, and click on the Protection tab. (Alternatively, under the Home tab, click on the expansion icon next to Alignment, and in the Format Cells window go to the Protection tab.)
    3. Uncheck "Locked" (which is checked by default) and click OK.
    4. Go to Review -> Protect Sheet and press OK to protect the sheet. Any cells you didn't unlock under the Format Cells option (step 3 above) will be locked, while the unlocked cells will be editable.

    This amendment adds currency formatting and autofits the two columns


    Try this. it also puts the column header on the left


    I don't like using Selection, that relies on the user remembering to select the right range.


    How is the data laid out, is it a Table? Can it be defined in the code? A small example workbook would help.


    I'm also, wondering if the name could be stored as a name.


    Code
    1. ThisWorkbook.Names.Add Name:="NewName", _
    2. RefersTo:=fileSaveName, Visible:=True

    Try this

    For speed I would use AutoFilter depending on the data layout. This code can be adapted



    It's not clear what your variables are, but try this


    Maybe


    I'm not sure what is happenibg. I've tried setting the InitialFileName but that doesn't work. I'll keep looking.


    Try this