macro to change data in inactive sheet
 

My document has two sheets. I am trying to write a macro that will allow me
to change data in a second inactive sheet by selecting the radio button on
the sheet that is open. I am able to change the data but the problem is that
the second sheets open when I run the macro and I want to be able to change
the data without opening that sheet. I would prefer to keep it hidden or
closed. Is there a way to do this.

macro to change data in inactive sheet
 

Can you post your macro so we can take a look?


--
protonLeah
------------------------------------------------------------------------
protonLeah's Profile: http://www.excelforum.com/member.php...o&userid=32097
View this thread: http://www.excelforum.com/showthread...hreadid=537322