Hello All

I have a userform which appears on opening the file. Everything worke
fine during testing.
I shared the file over a LAN and tested. Everything seemed OK
everyone can access the file via a shortcut on their desktops, howeve
I have run into problems which I cannot solve.

One user opens the file and Excel hangs before the userform is shown.
They can only close the file via the manager.

The problem seems specific to one profile as when I log onto the sam
PC everything works ok. The user has the same problem nomatter whic
PC they use to log on.

Does anyone have any suggestions?

Kenny
Using Win 2000 and Office 97
Code below is the startup code

Private Sub Workbook_Open()

'Sheets("Data").Unprotect password:="china"
'Sheets("Lists").Unprotect password:="china"


ThisWorkbook.Unprotect password:="china"


Sheets("Data").Visible = True
Sheets("Lists").Visible = True

Sheets("Data").Select
Sheets("Data").Range("A2").Select


MyPersClose

Load LogEntry
LogEntry.Show


End Sub

Sub MyPersClose()
On Error Resume Next
Windows("PERSONAL.XLS").Close ' in-case Personal.xls is not there
End Su

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