Little confused as to what you are saying... You mean before I add it in Workbook_Open, to check if an instance of it already exists, then delete it?
And assuming the above is correct, I am having trouble implementing .FindControl.
The below doesn't work..
what does .findControl return if it doesn't exist? Or should I be using .FindControls?Code:set temp = Application.CommandBars.FindControls(CommandBar, , "test970") If Not temp = Null Then myThing5.Delete End If Set myThing5 = Application.CommandBars.Add("test970", msoBarPopup, , False) UserForm1.Show vbModeless




Reply With Quote