ExcelBanter

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/332430-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
 

Did not work,

This still creates a saved file that has no Sheet1 worksheet, bu
maintains its module as a VBE object. I know for a fact that th
procedure does delete the module, but only at the end of the macro. Th
module disappears from the VBE, but the file had already being saved. I
I save a second time, the module is then gone in the saved file, but
don't want to ask the user to save twice

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



All times are GMT +1. The time now is 07:03 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com