I have a file that is on the network which I would like remote users to be
able to access simultaneously to input data. Also each should be able to save
there changes. One of the problem is that most of the users still have Excel
2003. The file was created in 2007 but is saved as 97-2003. One of the
problem is that when some users one the file, they get an error on this code
"ws.Visible = xlSheetVisible" from the section below. I can't figure out why.
For Each ws In Worksheets
If ws.Name = InputForm1.cmbMarket.Text Then
ws.Visible = xlSheetVisible
ws.Select
Exit For
End If

And also, some of the columns in the file are blank even though they contain
some values and formatting when I open the file. Another strange thing is
that when I attached the file to an email and sent it, the same problem
occured but when I emailed the file directly from excel the file was fine and
everything worked the way it was suppose to and the user was able to use it.
Any ideas what is going on here.

Tools Share Workbook Allow changes... Ok

Be forewarned, you may encounter some erratic behavior if the file size is
about 1MB. It may work for you and may not; the behavior is pretty
erratic... Thats all I can say about that; I never figured out why it does
this.


HTH,
Ryan---

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"Ayo" wrote:

I have a file that is on the network which I would like remote users to be
able to access simultaneously to input data. Also each should be able to save
there changes. One of the problem is that most of the users still have Excel
2003. The file was created in 2007 but is saved as 97-2003. One of the
problem is that when some users one the file, they get an error on this code
"ws.Visible = xlSheetVisible" from the section below. I can't figure out why.
For Each ws In Worksheets
If ws.Name = InputForm1.cmbMarket.Text Then
ws.Visible = xlSheetVisible
ws.Select
Exit For
End If

And also, some of the columns in the file are blank even though they contain
some values and formatting when I open the file. Another strange thing is
that when I attached the file to an email and sent it, the same problem
occured but when I emailed the file directly from excel the file was fine and
everything worked the way it was suppose to and the user was able to use it.
Any ideas what is going on here.