veryhidden sheet make restrictions ?!

  • Thread starter Thread starter Marie J-son
  • Start date Start date
M

Marie J-son

Hi,

I had a part of code using copy paste and got error all the time. Since I
had the workbook protected, I tried with getting rid of the paste events
with code below, but error remained.

If Sheet120.Range("M115").Cells.Value = "ACCEPTED" Then
Sheet120.Range(Cells(antRow, 1), Cells(antRow, 11)).Value =
Sheet120.Range("A115:K115").Value
End If

Then I guessed as a longshot that it had something to do with I had the
sheet as veryhidden as well and then it worked fine.

It is obvious that was the trick, because making sheet visible is the only
thing I changed, but I would like to have a confirmation from you genious.
What more restrictions do you got when sheet = very hidden? I don't like
surprises of this kind...

Comments?

/Regsrds
 
Forget it, it was a strange problem I have to check more closely, I made a
workaround for now.
I'll be back with it in time

/Regards.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Validation OK to named ranges in Veryhidden sheets? 8
Deleting veryHidden worksheets 5
Help with code 3
VeryHidden causing a problem...? 3
Value from one sheet paste under same value on other sheet. 7
Convert Macro into UDF 3
Code copies ONLY last j from sheet 9
Find the correct sheet then find a value on that sheet 8

Back
Top