ExcelBanter - Macro to delete sheets and saves remaining file does not properly delete module

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Macro to delete sheets and saves remaining file does not properly delete module (https://www.excelbanter.com/excel-programming/332428-re-macro-delete-sheets-saves-remaining-file-does-not-properly-delete-module.html)

pherrero

Macro to delete sheets and saves remaining file does not properly delete module

This happens even if the deleted sheet had no code. You end up with
file that deletes Sheet1, but has a blank Sheet1 module - what I nee
is for the Sheet1 module to not appear as a VBE object at all

--
pherreroPosted from http://www.pcreview.co.uk/ newsgroup acces

All times are GMT +1. The time now is 02:18 AM.