Each week I post a shared workbook to a network drive. The file is about
1.5MB. I have an ActiveX command button on a sheet named €˜Password and some
code behind that sheet to permit certain individuals to see certain sheets
and others can see other sheets, based on the login. I know Excel does not
have great security, but anyway€¦

Also, I have some code in €˜ThisWorkbook:
Private Sub Workbook_BeforeClose(Cancel As Boolean)
Call HideSheets
End Sub

So, when I close the workbook, all sheets, except for the sheet named
Password are hidden. When I run the workbook from my own computer,
everything works fine. When I post the file on the network, the behavior
become very unpredictable. For instance, sometimes, when the file opens, a
user cant click on the button named €˜Enter Password. The user seems to be
locked out of the file. If you close the workbook and reopen it may work the
second time it opens. Sometimes I have to do this several times before the
user can actually click on the button and enter a password. Also, when a
user clicks the €˜x in the upper right hand corner to close the file, the
sheets seem to get hidden, which is exactly what I want, and then the file is
saved, but then when another user opens the file, some of the sheets seem to
be randomly unhidden, and people that shouldnt see some sensitive data are
actually seeing confidential data...before the €˜Enter Password button is
even clicked.

Has anyone experienced this kind of erratic behavior? Again, when I run the
file from my computer, everything works fine. When I open the file from the
network, most of the time it works fine, but sometimes I get some very
unpredictable results.

Id appreciate any help or insight.


Regards,
Ryan---



--
RyGuy