Back to Top

Login | Register

Please Wait ..


Forum Home > Information Technology > Excel Macro, but why?
 




Recent Topics


Post New Topic


17 October 2014, 20:06  Report Abuse

Vaibhav Joshi

(F)CA, MBA aspirant



[ Scorecard : 1413]


Excel Macro, but why?

 

Everyone in finance field knows power of Microsoft Excel software. But if you aren't using macros yet, you don't know the half of it. Macros automate common and repetitive keystrokes that you use in Excel to create and edit spreadsheets. By reducing the number of keystrokes required to perform common commands, macros speed up your production and reduce the time you have to spend each day.

 

Macros offer many advantages to those who choose to use them. They reduce the possibility of human error that increases with many, repetitive keystrokes and tasks. Macros reduce the amount of time that must be spent performing basic computing tasks, freeing users up for more complex problem-solving and idea-generating activities. They also make complex computations easier to perform.

 

An Excel macro is a set of instructions that can be triggered by a keyboard shortcut, toolbar button or an icon in a spreadsheet. Macros are used to eliminate the need to repeat the steps of common tasks over and over such as:

Adding or removing rows and columns, protecting or unprotecting worksheets, selecting a range of cells, adding the current date to a spreadsheet.

 

In Excel, macros are written in Visual Basic for Applications (VBA). For those who cannot write VBA code, Excel allows you to record a series of steps - using keyboard and mouse - that Excel then converts into VBA. Excel has a built-in tape recorder, that listens and records everything you do, in Excel’s own language, ie VBA. Who don’t know any VBA, can use this recorder to record our actions and then we will see recorded instructions (called as code in computer lingo) to understand how VBA looks like.

 

In order to record and use macros (and other developer features), the first step is to activate Developer Ribbon (or Developer Toolbar). This is done by,

1. Click on Office button (top left)
2. Go to Excel Options
3. Go to Popular
4. Check “Show Developer Tab in Ribbon” (3rd Check box)
5. Click ok.

 

We will cover recording part in next tutorial.



16 January 2015, 22:32 

Noor

ceo



[ Scorecard : 28]


Wonderful articel sir.

I had learned the macros in my IT training but forgot about it, but you reminded me its potential.

Thank


21 April 2017, 15:15 

vexma





[ Scorecard : 34]


  • Disable all macros without notification Click this option if you don't trust macros. All macros in documents and security alerts about macros are disabled. If there are documents that contain unsigned macros that you do trust, you can put those documents into a trusted location. Documents in trusted locations are allowed to run without being checked by the Trust Center security system.

  • Disable all macros with notification This is the default setting. Click this option if you want macros to be disabled, but you want to get security alerts if there are macros present. This way, you can choose when to enable those macros on a case by case basis.

  • Disable all macros except digitally signed macros This setting is the same as the Disable all macros with notification option, except that if the macro is digitally signed by a trusted publisher, the macro can run if you have already trusted the publisher. If you have not trusted the publisher, you are notified. That way, you can choose to enable those signed macros or trust the publisher. All unsigned macros are disabled without notification.

  • Enable all macros (not recommended, potentially dangerous code can run) Click this option to allow all macros to run. Using this setting makes your computer vulnerable to potentially malicious code and is not recommended.

  • Trust access to the VBA project object model    This setting is for developers and is used to deliberately lock out or allow programmatic access to the VBA object model from any Automation client. In other words, it provides a security option for code that is written to automate an Office program and programmatically manipulate the Microsoft Visual Basic for Applications (VBA) environment and object model. This is a per user and per application setting, and denies access by default. This security option makes it more difficult for unauthorized programs to build "self-replicating" code that can harm end-user systems. For any Automation client to be able to access the VBA object model programmatically, the user running the code must explicitly grant access. To turn on access, select the check box.

3d printing technology





Related Topics / Similar Threads

More..

Post your reply for : Excel Macro but why

Your are not logged in . Please login to post replies
Click here to login


Not a member yet ?? Click here to signup

Message




Subscribe to the latest topics :




Sign-in to your account


Username:
Password:

Remember Me

Forgot your password?

Sign-up now



Join MBAclubindia.com and Share your Knowledge. Registered members get a chance to interact at Forum, Ask Query, Comment etc.