Hi All,
I am creating a tool for engineering...so far I have changes recording done, thanks to Hippiehacker.
I need now a macro that will be trigerred by a button "2. Exit Editing BOM & Save as new revision" located in Worksheet: "Multi Level BOM" - which I will refer to as "button".

Before Engineer starts to edit BOM (Bill of Materials) he needs to move / copy current revision of the BOM to dedicated location so that current version of the BOM may be stored. It would be good if this activity can be done by pressing mentioned button...button should trigger a macro.

Macro needs to do following:

1. Create New worksheet with name: BOM Rev. XX (Where XX is a number generated by macro...XX has to follow the value in Worksheet: "Revision Table" collumn "i" (i for Ireland)
2. Copy current BOM ranging B13:X1034 to that worksheet
3. Protect and hide that worksheet
4. Add newly created worksheet to the COMBO BOX located in Worksheet: "Multi Level BOM"
5. Allow open COMBO BOX open all positions from drop down list into the new Excel Workbook

Is there anybody that can help?





Multi Level BOM & Part List_3July2014.xlsm