Re:Macro pour fichier comptable SUN
see the worksheet menu bar
expand the tools menu
expand the macro submenu
launch the 'New Macro ' or 'record new macro' command.
a dialogbox pops up.
indicate the name to be given to the future macro
set a shortcut if necessary (beware not be in cnflict with standard shortcuts)
indicate if the macro is to be recorded in a excel user-specified macro workbook, usually called 'perso.xls' or if it is to be recorded inside the present workbook itself.
validate the dialogbox.
an other toolbar with a stop button should appear.
do the actions you want to be recorded.
then stop the macro.
display the visual basic editor through the macro submenu to see and change the macro.
__________________
STéphane
|