title: changing values in cells across multiple sheets with macro
body: <p>I'm quite new to VBA, and have limited Excel knowledge compared to what I read on here. I am having trouble with my macros. I have a 4 sheet workbook. Each worksheet has basic command buttons that issue a simple macro( which is to minus 1 from one cell value, and add 1 in another). Where I am having trouble is creating the macro code for 3 of the buttons. These buttons need to issue similar commands,however I need them to adjust select cell values across all the worksheets,not just the active sheet the buttons are located on.</p>
  
  <p>These 3 particular command buttons are located on "sheet 4". The cells are located across all 4 worksheets.Can I create a macro(activated by the single button click) that works across all 4 sheets? </p>
  
  <p>Button 1 - needs to add 1 to the value of cell g10 on sheet 4 
           - but also minus 1 from the value of cell c4 &amp; c7 on sheet 2<br>
           - and minus 1 from the value of cell c6 on sheet 3.</p>
  
  <p>The other buttons are all exactly like this. I hope this explains enough. I am currently reading books on Excel and VBA,but being quite busy this is slow. Any help is greatly appreciated. Thank you in advance. Frosty :)</p>