Im trying to put a command button on a spreadsheet i use for work.

I can make the button on the spreadsheet, but i am having troubles
assigning anything to it. It has been too long since i have done
anything like this

The button is in the Data file
This is a list of things i am hoping to have happen when the button is
pushed.
* Save As (Trans file)
* open (report file)
* Update the data in the report file which is being transfered from
Trans file.

Not to complicated i know, but for some reason i cant find how to
assign anything to the command button

Any Help would be very greatfull.

PS - If not to hard maybe some errorchecking could happen. Make sure
that the data balances before it saves the data to the transfer file.

I have error checking in the file already, but i was thinking that it
could let you know if u try and transfer the data when it does not
balance.

TY


--
XCESIV
------------------------------------------------------------------------
XCESIV's Profile: http://www.excelforum.com/member.php...o&userid=24271
View this thread: http://www.excelforum.com/showthread...hreadid=378865