Userform does not always show on startup over LAN
 

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

Userform does not always show on startup over LAN
 

do you use code like

Workbooks("bookname")
rather than
Workbooks("bookname.xls")

with the extension. This often causes an error while using the extension
works regardless of local settings.

You can also go to the users machine and clean out the temp directory and
any sub directories below temp such as Excel9.0 or VBE. Obviously this
would be for the profile that is having the problem.


--
Regards,
Tom Ogilvy


"N E Body " wrote in message
...
Hello All

I have a userform which appears on opening the file. Everything worked
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, however
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 same
PC everything works ok. The user has the same problem nomatter which
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 Sub


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

Userform does not always show on startup over LAN
 

Many thanks Tom

The cleaning of the temp files did the trick - The userform load
visibly faster than on other profiles!

Kenn

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

Userform does not always show on startup over LAN
 

Hello

Sadly I was wrong. The clearing of files was only a temporary fix.
The next day I am back to square one.

Anyone any ideas?

Kenn

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