![]() |
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