macros

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Macros

Macros

resolvedResolved · Low Priority · Version 2007

Sally has attended:
Excel Intermediate course

Macros

Can you create a macro for all functions you may use?

RE: Macros - Functions!!

Dear Sally

Thank you for attending Excel 2007 Intermediate/Advanced course!! I hope you enjoyed the course and benefited from it.
Macro can be created NOT ONLY for Functions BUT ANY group of tasks that you repeatedly perform!! For example if you find yourself changing the formatting of certain cells to currency with zero decimal places and any negative numbers in red, Bold and center justified. All these actions can be recorded as one macro command and can be performed with a click of a button if you assign the macro to a button on the Quick Access Toolbar!!

Coming to your original question Yes any function can be recorded as a macro. This is particularly helpful if the spreadsheet is going to be used y someone who has no understanding of formulae/functions!! Or if that function is very complicated and needs to be entered in various location in the same worksheet or different worksheet. Please always remember to press the relative button so the cells change accordingly when the macro is applied to different cells
I hope this has answered your query.

If this has answered your query then I would request you to please mark the question as resolved!! If not and you have a specific question related to this then please post it as a new question and we should be able to provide you the solution for it!!

Kindest Regards


Rajeev Rawat
MOS Master Instructor 2000 and 2003
MCAS Master Instructor 2007


 

Excel tip:

Switching Between Spreadsheets

As the Alt+Tab key switches between loaded applications or files, Ctrl+Tab switches between loaded or open Excel files. Hold down the Ctrl key until you have tabbed to the correct spreadsheet.

View all Excel hints and tips


Server loaded in 0.07 secs.