macro to change data in inactive sheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
You could turn off screen updating at the beginning of your macro, then turn
it back on at the end.

Application.ScreenUpdating = False

Application.ScreenUpdating = True

HTH,
Elkar
 
You must log in or register to reply here.

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

Macro to change data in a sheet 1
reading data from hidden sheet 4
copy hidden sheet data 2
Select dynamic data in 2 columns, and repeat macro to next sheet 2
Help to create a macro 2
Excel Move or Copy Stopped Working? 0
i need to find the exact location of macro to paste in the existing macro need to get the out put co 0
Merge Multiple workbook sheets into one workbook 0

Back
Top