only userform show without open excel file/excel file hide and userform open /userform show VBA code 

infosoft
this video is related to excel file hide and only show userform your project
VBA code:-
private sub workbook_activate()
thisworkbook.save
thisworkbook.close
end sub
___________________________________________
private sub workbook_open()
thisworkbook.save
application.visible=false
userform.show
end sub
____________________________________________
if you confused pls comment