it will still disappear even though I use a savebutton

thisworkbook.saveas.filename: =

and having

Private Sub Workbook_Open()
userform1.show
End Sub

that when I reopen the workbook, all of the tabs wouldn't show?

perhaps doing something like

Private Sub Workbook_open()
userform1.show
call commandbuttons
end sub

?

--
Message posted from http://www.ExcelForum.com