MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.
Sub SaveBook() 'Saves the workbook If Range("checksave").Value = 3 Then MsgBox ("Created") ActiveWorkbook.SaveAs Filename:=Range("path").Text & Range("filename").Text On Error GoTo Err ::::My code here Else: MsgBox ("You must enter a MID and Customer ID and Business Name before saving.") Exit Sub End If Err: MsgBox ("You must enter a MID and Customer ID and Business Name before saving.") Worksheets("Dashboard").Shapes("Rounded Rectangle 50").Delete End Sub
|Automating an Excel Template using VBA and Outlook||8||32|
|Copy and Paste Text into Text Box||3||29|
|Loop with matrices. Please help me!||16||43|
|In Excel 2007, how should I correct my IF ERROR formula to avoid #VALUE! error||15||21|