I have made the sheets hidden and veryhidden using the properties in VB.


Yours is a puzzling post because (1) it's not possible to hide _all_ the
sheets in a workbook, that is, at least one has to be visible, and (2)
sheets hidden are hidden for all users.

Anyway, if you want a workbook to have no visible presence you should save
it as an add-in. You can do this from the File, Save As dialog and also by
changing its IsAddin property to True.

If you do this there has to be some way to trigger the userform to open, but
I assume you've already got that going (like an Workbook_Open event
procedure).

--
Jim Rech
Excel MVP