Recent content by kris44

It's because of the ActiveWorkbook.Close event is before the ThisWorkbook save event, so it's closing without saving Private Sub Button1_Click() Range("C18").ClearContents Range("C21").ClearContents Range("G6").ClearContents Range("G7").ClearContents Range("G8").ClearContents...

I've modified your spreadsheet and put some formulas in Rows 18 & 19 (Also played around with some of your Defect Numbers) You can see the formulas to use are INDIRECT & ADDRESS, hopefully with the examples given you can work out the remaining formulas you...

Our steel supplier has given us test results for Q345B. For Impact Test at 0°C the results are 150, 151 and 177 J. I don't have any experience in this area, but to me it seems very high when you consider the Australian Standard requires only 27J Cheers.

In regards to your second question, another option would be to assign a mouse gesture (provided you are using SW2010 or 2011)

Another method is in the Custom Properties of the Part create a Property (e.g. "Length") linked to the dimension you want in the BOM. To link - place the cursor in the "Value/Text Expression" column then double click on the feature and then on the dimension that you want linked. Then in Custom...

Paste this formula into Cell B3 =INDEX(INDIRECT(ADDRESS(MATCH($A3,Output!$A:$A,0),1,,,"Output")):INDIRECT(ADDRESS(MATCH($A3,Output!$A:$A,0)+100,4,,,"Output")),MATCH(B$2,INDIRECT(ADDRESS(MATCH($A3,Output!$A:$A,0),2,,,"Output")):INDIRECT(ADDRESS(MATCH($A3,Output!$A:$A,0)+100,2,,,"Output")),0),4)

First let me say the best method is using "Helper" or "Calculation" columns as iken suggests, but if for some reason you want to use just one formula without adding any columns here goes If you paste the following formula into cell B2 of Loads & then copy across & down you will match what you...

For bolts best to have one only Cut-Revolve which indicates the length of thread.

D23, The video uses a method I used before (i.e. use the VeryHidden function). This can still be overcome by someone disabling macros in your workbook, then running a simple macro in another workbook which turns all sheets to Visible. Another possibilty is User Defined Fuctions - these don't...

It depends on how secure you want it to be & also how much do the people you send it to know about VBA. Various options include: 1 - When file opens look on the network for a particular file (that way if you're not on the network it will close the file) 2 - In VBA look at Application - there...

Another option is Right-click on the feature in the Feature Tree & select "Configure feature"

Our application has a screen inclined at an angle to the stream in a tank (open channel flow). The screen has horizontal & vertical bars as shown. The screen is inclined to the flow by some angle ? which I can determine for each application I'm struggling to find any equation that would fit our...

I used the following methods as required; 1. Use display states instead of Detail & Cropped Views where possible 2. Use Shaded without Edges 3. Hide all views except the one you're working on or only load sheets as you need them 4. Use derived configurations to remove complexity

Thank you - star for you

Does anyone have a Macro which will change all drawing views to a particualr Display Style (e.g. HLR, Shaded)? We like to show our assembly drawings in shaded but it makes it very slow to work with them.