Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TugboatEng on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by MechaPro
-
History of some of my Excel faux pas (boo-boos)
There is another way to protect your worksheet name, I use this all the time to maintain the integrity of my workbook. It can be done in Workbook BeforeClose or BeforeSave option Private Sub Workbook_BeforeClose(Cancel As Boolean) Dim WS As Worksheet Dim WSCount As Integer Dim...- MechaPro
- Post #14
- Forum: -Engineering spreadsheets
-
.bas File
The difference between SkipVought's code and the one you used is, The one that worked for you assumes a Default value of 0, if nothing is passed as an argument or a Null Value is passed. So having G1=0 obviously will give you an infinite value for the following operation, If (A1 / G1 > 2). You...- MechaPro
- Post #8
- Forum: -Engineering spreadsheets
-
Asme and CSA codes and standard
Not sure exactly what you are looking for. But here is one app which shows the necessary codes and standards by equipment type, Engineering Codes & Standards Hope this helps.- MechaPro
- Post #2
- Forum: Mechanical engineering general discussion
