Afficher un message
Vieux 07/06/2005, 15h12   #4 (permalink)
STephane
XLDnaute Occasionel
 
Date d'inscription: février 2005
Messages: 259
Envoyer un message via MSN à STephane
Par défaut 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
STephane est déconnecté   Réponse avec citation