Does providing Excel VBA access to employees create an information security risk?

Asked by Last Modified  

1 Answer

+1 Microsoft Excel Training

Follow 2
Answer

Please enter your answer

Nev Laishram

The companies or organizations which are wise provide Excel VBA access to employees as it helps increases productivity. Excel VBA access does not create information security risks, Per se'. The risk is instead that of bugs in the code resulting in bad decisions being made. The reason why VBA is so...
read more
The companies or organizations which are wise provide Excel VBA access to employees as it helps increases productivity. Excel VBA access does not create information security risks, Per se'. The risk is instead that of bugs in the code resulting in bad decisions being made. The reason why VBA is so famous is that every Office user has access to it. If you have a problem, you can actually use VBA to automate the routine tasks in your job and increase productivity. And if you share those VBA tools with peers, you can multiply their productivity as well. Information security risks occur if parties gain access to corporate databases (or worse yet, change them) who aren't permitted to do so. It requires a pretty sophisticated VBA coder to do that, and such a person can also circumvent any attempt by the IT Department to prevent access to VBA. It is far better to identify the people within the organization who have those skills and make sure you trust them. It is also to be noted that Information security risks also occur if parties outside the organization are given access to information exported from corporate databases. Lack of VBA access won't stop someone from copying such files onto a flash drive and letting it fall into the wrong hands. Hope this helps! read less
Comments
Dislike Bookmark

Related Questions

I want to learn network simulator ns3 for my project.
Drop me message.. I have learn concepts of NS3. May be I can help you out.
Vineeth
1 0
8
How to use vlookup in excel?
Syntax for using vlookup function is =VLOOKUP(LOOKUP_VALUE,TABLE_ARRAY,COL_INDEX_NUMBER)
Ankita
0 0
7
How to create pivot table in excel?
If you wan to analyze the only data that is on your sheet. First be sure all columns has header after than select any cell from your data and go to insert tab and click on pivot table.
Rahul
0 0
6

Make A Excel Software Challenge: To Track Time Records To Enhance Daily Output Of Staff
Through Time Sheets
Bikram Jeet
0 0
7
How can I create a letter head on excel?
Select a cell for typing the Title, change the font size in Formatting tool bar, merge cells in formatting tool bar depending on the length of title.
Jitendra

Now ask question in any of the 1000+ Categories, and get Answers from Tutors and Trainers on UrbanPro.com

Ask a Question

Related Lessons

SQL (Structured Query Language)
SQL (Structured Query Language) is a standardized programming language used for managing relational databases and performing various operations on the data in them. Initially created in the 1970s, SQL...

Itech Analytic solutions

0 0
0
Excel Tip: Conditional Formatting To Highlight First Value Among Duplicates.
In Column “C”, I have product list and some of them are duplicates. My requirement is to format with background color of green for 1st found value among the duplicates. To solve this, I used...

Karthik Dale

0 0
0
Excel Shortcuts
ShortCut Key Description F2 Edit the selected cell. F3 After a name has been created, F3 will paste names. F4 Repeat last action. For example, if you changed the color of text...

Afreen

0 0
0
VBA Function -
Using FORMAT Function in VBA we can modify the format of Numbers, Dates, Times & String. Syntax: FORMAT(expression, format, , ) 1. Formatting "Numbers" using FORMAT function in VBA SUB Format_Numbers() MsgBox...

Naga Satyanarayana anantapalli

0 0
0
My Experience on Recruitment for Data Analyst role.
Hi All, I want to share my experience here and why I chose to take up classes on Advanced excel. This is not technical lesson but a motivation to improve your skills. I was leading Data Analyst team...

Sai Krishna

0 0
0

Recommended Articles

Learn Microsoft Excel

Microsoft Excel is an electronic spreadsheet tool which is commonly used for financial and statistical data processing. It has been developed by Microsoft and forms a major component of the widely used Microsoft Office. From individual users to the top IT companies, Excel is used worldwide. Excel is one of the most important...

Read full article >

Top 5 Skills Every Software Developer Must have

Software Development has been one of the most popular career trends since years. The reason behind this is the fact that software are being used almost everywhere today.  In all of our lives, from the morning’s alarm clock to the coffee maker, car, mobile phone, computer, ATM and in almost everything we use in our daily...

Read full article >

8 Hottest IT Careers of 2014!

Whether it was the Internet Era of 90s or the Big Data Era of today, Information Technology (IT) has given birth to several lucrative career options for many. Though there will not be a “significant" increase in demand for IT professionals in 2014 as compared to 2013, a “steady” demand for IT professionals is rest assured...

Read full article >

Make a Career in Mobile Application Programming

Almost all of us, inside the pocket, bag or on the table have a mobile phone, out of which 90% of us have a smartphone. The technology is advancing rapidly. When it comes to mobile phones, people today want much more than just making phone calls and playing games on the go. People now want instant access to all their business...

Read full article >

Find MS Office Software Training near you
MS Office Software Training in Delhi
MS Office Software Training in Bangalore
MS Office Software Training in Mumbai
MS Office Software Training in Hyderabad
MS Office Software Training in Chennai
MS Office Software Training in Pune
MS Office Software Training in Kolkata
MS Office Software Training in Ahmedabad
MS Office Software Training in Gurgaon
MS Office Software Training in Jaipur

Looking for MS Office Software Training ?

Learn from the Best Tutors on UrbanPro

Are you a Tutor or Training Institute?

Join UrbanPro Today to find students near you