Have a code that copies one sheet from a workbook to another workbook. Both
workbooks are open. The sheet is not hidden when it is copied. On some
machines the sheet copies on others it doesn't. I recieve no error messages
either way. Both machines run same os and same version office. On machine
that does not copy, if I step through the code it will copy. I know noone can
probably help without seeing the code. But any suggestions?


--
When you lose your mind, you free your life.

Show us your code (or parts of it).
Indicate where it doesn't work (if possible)

--
steveB

Remove "AYN" from email to respond
"ben" (remove this if mailing direct) wrote in message
...
Have a code that copies one sheet from a workbook to another workbook.
Both
workbooks are open. The sheet is not hidden when it is copied. On some
machines the sheet copies on others it doesn't. I recieve no error
messages
either way. Both machines run same os and same version office. On machine
that does not copy, if I step through the code it will copy. I know noone
can
probably help without seeing the code. But any suggestions?


--
When you lose your mind, you free your life.

this line is in the userform activate code and is a public variabl for the
userform
Set thiss = ThisWorkbook.Sheets("LISTNAMES")

this code is run from a private procedure in the userform
Set tthisw = ActiveWorkbook
thiss.Copy after:=tthis
tthis.Activate
Set tthis = tthisw.Sheets("LISTNAMES")
tthis.Protect Password:="yellow"
tthis.Visible = xlSheetHidden

it is the copying of the sheet that does not work
--
When you lose your mind, you free your life.


"STEVE BELL" wrote:

Show us your code (or parts of it).
Indicate where it doesn't work (if possible)

--
steveB

Remove "AYN" from email to respond
"ben" (remove this if mailing direct) wrote in message
...
Have a code that copies one sheet from a workbook to another workbook.
Both
workbooks are open. The sheet is not hidden when it is copied. On some
machines the sheet copies on others it doesn't. I recieve no error
messages
either way. Both machines run same os and same version office. On machine
that does not copy, if I step through the code it will copy. I know noone
can
probably help without seeing the code. But any suggestions?


--
When you lose your mind, you free your life.

well i've solved the mystery but it still is wierd. The sheet was copying but
when it hid the sheet i could no longer access it from vb on certain
machines. One being office 2000 another being office 2003. other machines
would. oh well at least i know where to go from here.

--
When you lose your mind, you free your life.


"ben" wrote:

Have a code that copies one sheet from a workbook to another workbook. Both
workbooks are open. The sheet is not hidden when it is copied. On some
machines the sheet copies on others it doesn't. I recieve no error messages
either way. Both machines run same os and same version office. On machine
that does not copy, if I step through the code it will copy. I know noone can
probably help without seeing the code. But any suggestions?


--
When you lose your mind, you free your life.