To create a button, View, Toolbars and ensure Control Toolbox it
ticked.

the first icon on thatt bar reflects 'Edit Mode', click that, then
click the button icon.

click (or double click) in the cell to make a button, and right-mouse
Properties to set a Caption Name "Update Day Figures" and a button back
colour
click View Code and enter the code previously shown.

Then click the 'Edit Mode' icon again (which now shows 'Exit Edit
Mode')

Let me know how you go


n0 h4ck1ng Wrote:
ahhhh ok i get it now, thank you now if you could tell me how to make
this button and where to enter the code i should have my problem solved
i have toyed around with VBA but have not actualy used it yet

thanks again this solution will take off at least two days worth of
work out of my month
:)


--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=395696