Perplexing sheets.

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" <bw_rgb@hotmail.com(remove this if mailing direct)> wrote in message
news:12F68F6A-9BB6-438E-9A12-DB4A8E12CD05@microsoft.com...
> 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" <bw_rgb@hotmail.com(remove this if mailing direct)> wrote in message
> news:12F68F6A-9BB6-438E-9A12-DB4A8E12CD05@microsoft.com...
> > 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.