Displaying a Form without showing the worksheet

[mohanse]

I have created a form that converts latitude / longitude from Decimal Degrees to Degrees Minutes Seconds decimal seconds. I want my coworkers to be able to use the form, but I don't want them to see the excel window/worksheet when they open it up.... I thought I had received an email once that appeared to be an excel file but when you opened it, it was just a form. I have tried all I can think of to no avail. Any help would be greatly appreciated.

[Paul]

Hello Mohanse, and welcome to the forum.

In the Workbook's Open event, use code such as:

Application.Visible = False
MyForm.Show

On the form's close event (or QueryClose event) you may want to set it back to Visible = True.

[mohanse]

HA! Perhaps it was just too easy to try....I had the show form in there but not the application visible part. Worked like a charm.....Thanks

[royUK]

You need to make sure that you have some error handling to make the application visible.

Something like

Private Sub UserForm_QueryClose(Cancel As Integer, CloseMode As Integer)
Application.Visible = True
End Sub

This sort of code can easily leave the user with a hidden insyance of Excel running