Is it possible to remove or prevent or blank rows at the end when saving an excel file as a CSV, if they are created by cells with formulas in a worksheet that is protected (rows cannot be deleted)? The formulas are basically =IF(Data!B2="","",Data!B2) links to either bring data from another sheet or another cell in the same worksheet, with a few IF statements thrown in.
The entire point of the protection is to prevent rows from being deleted, so I stop having to go in and fix a workbook that is "broken" because the user deleted rows containing formulas linked to another worksheet (again). This means that deleting blank rows at the end before saving isn't possible. Barring macros, am I stuck with the blank rows at the end?
(Yes, copying the data to a new sheet and saving it from there would fix it, but is not going to happen. Please keep in mind we are talking about an end user who keeps deleting rows after being told it will break the sheet, and whose response to any problem in a workbook that has had a macro run in it is "the macro broke it". Yes, I might be a little salty.)
The entire point of the protection is to prevent rows from being deleted, so I stop having to go in and fix a workbook that is "broken" because the user deleted rows containing formulas linked to another worksheet (again). This means that deleting blank rows at the end before saving isn't possible. Barring macros, am I stuck with the blank rows at the end?
(Yes, copying the data to a new sheet and saving it from there would fix it, but is not going to happen. Please keep in mind we are talking about an end user who keeps deleting rows after being told it will break the sheet, and whose response to any problem in a workbook that has had a macro run in it is "the macro broke it". Yes, I might be a little salty.)
