View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
dunnerca dunnerca is offline
external usenet poster
 
Posts: 22
Default Unloading /Closing all userforms

I've searched all over and cannot find an example of coding that will close
all open user forms. I'm thinking something like

For i = 1 To Controls("msforms").Count
Unload ?
Next

As you can see, that's a really rough estimate of what's needed.