Thread: Removing a Form from VB Automatically
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Trey via OfficeKB.com Trey via OfficeKB.com is offline
external usenet poster
  
Posts: 1
Default Removing a Form from VB Automatically
Does anyone know how to remove or delete a from.
I can do this with a module but am having issues with a Form. Here is the
syntaxt I use for a module

Set VBComp = Workbooks(RollUpProg).VBProject.VBComponents("User Form1")
ActiveWorkbook.VBProject.VBComponents.Remove VBComp

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200512/1
Reply With QuoteReply With Quote