Thread: Macro to delete sheets and saves remaining file does not properly delete module
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
pherrero pherrero is offline
external usenet poster
  
Posts: 4
Default 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

Reply With QuoteReply With Quote