PDA

View Full Version : Select a cell in sheet2 when I'm on sheet1?



doctortt
05-06-2011, 07:42 PM
I have a button on sheet1 that will restore the values of certain cells back to default (all values are on sheet1.) But I want to be able to do this - whenever I click on sheet2, the A1 box will be selected. How do you do that?

Basically, is it possible to add some codes in my restore button that's on sheet1 one to make sure the *highlighted* cell is always A1 on sheet2?

macropod
05-06-2011, 11:49 PM
Hi doctortt,

You shouldn't need to select/highlight (activate) any cells on either sheet - simply address them directly.

Perhaps if you could explain what you're trying to achieve, and post the code you're using, a better way could be worked out.