All that you should know about Macros before working on them

Asked By avah.hannah 30 points N/A Posted on - 12/03/2014

How do Macros help to make my work easier in Excel? Is it possible to hide the Macro that I am using so that others do not see it? Why do I see a prompt which reads  "Enable or Disable a Macro" sometime on my workbook when I am working with macros?

 

• Status: Open
• Question Views: 527
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS Excel

Answered By Derick Harris 0 points N/A #200157

All that you should know about Macros before working on them

Hello Avah,

Macro is a tool in Excel through which you can perform a complex task with just one click. Suppose you need to calculate and analyze data that are present in column A, B, C. Now you need to do various calculation between data of these 3 columns. You need to just do this calculations one by one serially after click record macro. After finishing the calculations just click stop macro. Now when you run this macro with a new set of data those serialize calculations will done automatically by excel and hence it is reducing time and effort.

Every workbook which has macro will be saved as an macro enabled workbook. So if other person open it he or she will be able to use your macro as there is no option for macro hiding.

Enable macro means if you enable then the sheet will be eligible for macro run, disable means the sheet is not eligible for macro run. We are basically enabling and disabling macro run through that prompt.

Regards,

Derick Harris

About Derick Harris

Questions
0

Answers
27

Best Answers
3

• Vote Up 0 Vote Down

• Posted on - 12/05/2014
• Question Category: MS Excel