View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] support.presentationpro@gmail.com is offline
external usenet poster
 
Posts: 3
Default I need help deleting macros and VB controls and saving as new workbook

I am trying to copy a sheet from a workbook then create a new file with
the file name as cell H4 then I need it to delete all of the macros
and command buttons THEN I need to protect the whole new file so
nothing is editable its for an invoice.