software

iM TRYING TO INSERT A PRINT FUNCTION IN AN EXCEL SPREADSHEET SO THAT WHEN
CLICKING CELL IT WILL AUTOMATICALLY PRINT THE SHEET.

select tools--gt;macro--gt;record a macro,
when asked for the macro name type: Print
under quot;Store inquot; select quot;This workbookquot;
click ok
perform the print operation,
select tools--gt;macro--gt;stop recording
select view--gt;toolbars--gt;control toolbox
click the design button (green triangle)
click the command button icon
click somewhere on your sheet, hold and drag to the right and down to
create a button
right click in the new button and from the context menu select 'view
code'
between the lines quot;private subquot; and quot;end subquot; type the name of your
macro which was 'Print'
close the VBA window
on your sheet click the design button
click the new button to test it.

Hans