Display a form but not the spreadsheet

[ewan1979]

Hi,

I am trying to devise code that when I open a spreadsheet it wont be visible however an entry form will be displayed. I have tried the code below, however it either doesn't display the form or makes the form visible and the spreadhseet visible.

Private Sub Workbook_Open()

Trade.Show

Windows("Trade Register.xls").Visible = False

End Sub

Essentially what I want to do is to have a form display when I open the spreasheet to allow the user to input the data, without seeing the excel workbook - just the form. Any help would be greatly appreciated.

Thanks,

Ewan

[ewan1979]

Hi,

I am trying to devise code that when I open a spreadsheet it wont be visible however an entry form will be displayed. I have tried the code below, however it either doesn't display the form or makes the form visible and the spreadhseet visible.

Please Login or Register  to view this content.

Essentially what I want to do is to have a form display when I open the spreasheet to allow the user to input the data, without seeing the excel workbook - just the form. Any help would be greatly appreciated.

Thanks,

Ewan

[romperstomper]

Hi,
You need to hide the workbook before you open the form (since your code will stop at that point, unless the form is modeless).

Note also that I corrected your tags from Quote tags to Code tags.

[royUK]

You can hide the Excel application, but I wouldn't recommend it unless you can cope with any problems that might occur

[snb]

method 1

Please Login or Register  to view this content.

method 2

Please Login or Register  to view this content.

method 3

Please Login or Register  to view this content.

method 4

Please Login or Register  to view this content.