My company has locked down our Excel so that we can no longer access the VBA Editor (it’s greyed out and Alt F11 doesn’t work). However I can still access the Word VBA Editor. Is there a creative way I can launch the Excel VBA editor via the Word version, or somehow run Excel VBA code via the Word version?

likehelpful
Posting as :
works at
You are currently posting as works at

Weird, cause VBA is shared. Are you sure the VBA add-in is turned on? (Go to Options -> add-in -> find the VBA and press OK

About opening it through word, you can't directly open a excel VBA panel through word - you could in theory build an entire excel model through word and pass it to a new book on excel, but I wouldn't go for that road: too much work for too little gain.

Either talk to your IT department or do it in a personal laptop and send the file to yourself.

I am starting to dig into Power Query to see how much of this can be replicated there. I know very little of it so probably will be a lot of trial & error.

Sorry to hear that but that is the banking world. I have had to use tableau or power bi to automate my processes. Maybe you can find a work around when using code to automate.

You gotta figure out how to “backdoor” it somehow. Or sign in to your personal MS Office account in an incognito browser 🤷🏼‍♀️

As a VP, do you have the power to decree that your IT department either turn VBA back on or they develop all VBA requests within a reasonable turn around time?

I've worked for multiple fortune 500 companies that paid oodles for their ERPs, but upon closer examination, almost all processes are cobbled together by the Shadow IT of Excel, Access, and VBA. Without VBA, they'd have to triple their headcount and they'd be subject to a dangerous number of errors.

Related Posts

I recently joined FIL as Lead BA. Is there any chance of on-site travel? Is there any team where on-site movement is easy?

like

Hi Everyone,
What all tickets can come under LTA? Can hotel receipt be calculated as LTA ? Bus tickets , aur tickets for to and from base location be calculated as LTA ?

like

Anyone have the Delta 360 number? Can't get through for hours on the diamond line.

like

I stopped contributing to my 401K for the last three months in order to pay off credit card debt. I am 28 and have about 68K in my 401K. Was this a smart decision? I want to get out of debt as quickly as possible and I have no student loans or car debt.

Us open grounds passes for sale. Two for Friday for $80 each, two for Saturday for $115 each. Flight to NYC was cancelled this morning :-(.

like

Anyone know the salary range for a Supervisor at Frosch in their Luxury Travel division?

Hi did anyone tried using ICICI Amazon credit card on recognise Accenture portal. I am short of 4 RP points to get 5000 Amazon voucher when i used Credit card for that 4 points it shows your transaction has been rejected by your bank

like

Newbie here! Looking for a CANADIAN credit card recommendation. Work provides Amex green for hotels and meals - flights and Ubers are paid directly by McK. I have a personal Brim MasterCard for the 0 exchange fees and a CIBC Aventura which offers minimal points. My main expenses are food and transportation, I rarely spend more than $1k per month, and I would ideally like a lower annual fee because I don't think I'll spend enough to recoup the cost of a higher fee. I'm signed up for Aeroplan.

Fish fam.. please suggest laptop bag for daily use and travel? Looking for an affordable, value for money option ~$100-150. Thanks!

like

Hi
Does anyone know how the Sainsbury DTD tech teams work?
I recently got an offer for a London location but it says I should be prepared to travel at least 2 times a week, but the number of travels depends on the team.@sainsbury

Couples: What are some things you have done to make the separation easier when you’re traveling? About to travel for the first time and need tips since my bf is on the needier side of things

like

Looking for feedback. What are your thoughts on when asked to provide a case study or project plan as a part of the interview process? I know BCD Travel and other start-ups make these kinds of request.

like

Best spg or Marriott property near Lake Tahoe?

like

I'm looking at A&M (Senior Associate, Operations--Process Industry Team).

How's the work itself and any insights on WLB and travel?

like

Hi everyone,

Looking for a job change, working as a Sr. Representative , have an experience of 4.5 yearsin travel and
Banking domain, any help will be greatful

like

i'm looking into getting an american express credit card.. this will be my first credit card, i do a lot of driving and traveling what would be the best one to get?

like
like
like

I am using my first credit card from last 4 months. Can i apply for second credit card? Will this hamper my cibil score?

I am utilising less than 30% limit on my first card.

like

Anyone have a referral for a retail field trainer? We are a luxury, Seattle based brand. Location is remote with about 50% travel. Preferably located in the LA market. Salary range is $90-$100k plus bonus and competitive benefits.

More Posts

Hi,

What Skill set is required for IT Business Analyst?

How to get into Human Resources with a Master Degree in Psychological Organization Leadership

like

Microsoft feature request for Teams - can you please make the current participants in a meeting visible before a person joins?

like

Hello Fishes?

Need suggestions

What someone should do if you are team leader says you have to take treatment for not to forget some task?
My team leader is constantly asking (daily~7-8 times) for the work status apart from daily stand-up. I have recently joined this company 6 months back.

He is literally trying to prove that I don't know anything.
I am not feeling working or going to office. Feeling demotivated.
I can talk to the his superior as they are from the same gang.
Help appreciated

like

Looking for recos on internal trainings to provide for entry-mid level employees at the company that would be appreciated/add value/make their lives easier or more confident.

(I.e. client etiquette for newbies that haven’t had exposure or just haven’t been in office bc of Covid, leading meetings, managing up, working in person 101, etc.)

like

Hmm wondering if anyone can help with this one, I'm moving to New York at the end of this year, a B2B content marketing manager (focused on SEO content including analytics, optimisation etc.) with 7+ years of experience in content and other marketing roles.

Finding it really difficult to gauge what salary i should be asking for in NY, with my experience in a similar (digital content/content marketing manager role) - can anyone help?

like

Really haven’t posted my gains in a while, but I never believed I’d actually reach these amounts.

like

Would love to speak with anyone who made an exit from consulting shortly after reaching M. How did you think about the following?

1. What functional roles will you actually be good fit for? How does one really know? My resume of case work just confuses me tbh

2. What level should you / did you shoot for? Is AD a realistic goal?

3. What platform did you use to search for jobs? LinkedIn?

3. How did you shortlist your set of target companies?

4. How did you ultimately land the "right" job?

likehelpful

Best way to get away from work for ~2 hours for an interview? What to say?

like

Hi....anyone from FUJITSU LIMITED who can help me with referral?

like

I’m a 3rd year RE associate who just migrated out of Big Law to in-house RE Private Equity. Salary is 200k, and bonus last year was $125k ($325k all in). Want to know if this is comparable to big law, now that there’s such a huge rush for associates.

like

Hi friends ., I asked 25 LPA as Fixed salary hoping to get 2 lakhs in hand., But she released offer 25 including PF,Gratury, Superannuation can I discuss now? Not accepted this offer yet.please suggest.

Post Photo
like

Please help me to Enable DM.. please like this post so it will be helpful for me. Thanks in Advance.

like

As far as claims adjusting, does working in the excess world make more money than working in primary?

like

Hello Folks,

I have work experience of 3 years as a developer.

I have received few offers.

TCS - 8.5 Lpa

IBM - 11 lpa

Oceanearing - 13 lpa

TransVirtual - 14 lpa

HSBC - 14.5 lpa

Siemens - 14 ctc + 2 bonus

What you think where should I join in terms of career prospect , work life balance , growth, culture?

Role is almost same everywhere.

like
like

I have joined ofss around a month ago. I have been asked to watch few videos and they have given work to me. I am not able to understand many things and have lot of questions, there's no one to answer. How can I tackle this situation?

like

Does anybody own one of these Ministry of Supply suits? Supposedly wrinkle-free, machine-washable, stretch, stain-repellent... the reviews are suspiciously enthusiastic too

like

Additional Posts in Excel Genius

Does anyone know of a good excel training online (pivot tables…filters…) ? (Preferably free)

like

I run a chatbot that collects students inquiries and want to spot reoccurring questions without going through all 4,000 questions. So far, I’ve created an advanced find keyword indicator to help bucket questions into themes, however I want to build an FAQ sheet. All/any help appreciated 😅

like

need to do a timeline with lots of information over a long period of time. I wanted to that in Tableau, but partner will not pay license and data is sensitive so I cannot use Tableau public.
Do you have suggestions?
The requirements are the following:
- No online input data upload (so local editing)
- The produced output file must be local and easily exportable and readable
-timeline must be interactive (filter/click/zoom in/out/view detals etc.)
- free

Any kind of help is really appreciated

like

Anyone work on a Mac and use parallels when in need of excel? If so, does it work or is it a big no-no? My work going forward will not primarily be excel, but I have to use it on weekly/monthly basis. Might also have to use some Power BI. Would love to go back to working on a Mac but excel has stopped me from buying one…

like

Anyone familiar with the fuzzy match add in, and if so, how do you run a fuzzy match within one column of information rather than two tables? I.e., I want to find close matches within one list of vendor names

likesmart

I know this is for excel, but any Tableau experts here can let me know how to present my mixed (countries, states, provinces) data on a map. I’ve tried dual axis but still not where I want it to be.

like

Is there an option to permanently turn off the research function in excel without using external add-on/plug-ins? Not sure why it exists in the first place...

like

Does anyone have experience setting up automated queries on Excel for Mac? I am trying to automate a paid search pacing document but am running into an issue with the Excel Power Query not being able to log in to Search Ads 360.

like

Would someone please explain in a simple way when to use an array? Is it for every index match formula every time?

like

Can you use the SUBTOTAL feature with formulas as well? Such as IF statements

like

Trying to count the maximum number of overlaps in at a given time in a series of date ranges. Finding an overlap is easy, but not sure how to cycle through date ranges while keeping a Max count

like

I have a 30 minute excel study case as the final step for a potential job. It would be a great raise and a step into the field I ultimately want to be in. The hiring manager told me that it is a basic test, more to see how much I know. However, I want to exceed expectations. I do use excel daily, but nothing too complicated. Does anyone have any tips or resources that might help me wow upper management and land this role? Thank you in advance.

likehelpful

Anyone ever work on a profitability assessment / improvement? Starting a project to optimize shipping margin based off 8 parameters. Never done something like this before, but first thought (cont.)

like

How do I automate an import of data?
Everyday we get a fresh set of data in an excel file.
It has certain columns of info that we need to pull into our template, I basically do a copy paste every day. The number of rows may vary from day to day so need to make sure to grab all data from all rows.

like

I love this bowl. Sorry, continue to share nerdy excel shortcuts which I loooovee.

like

Problem:
There is a table. Column A:D are mapped to column E with unique records. In a new column (Q), there is a list of values that that contain any randomized value from Columns A:D. What is the syntax to map Column Q to column E?

Is using INDEX/MATCH the right direction?

like

I’m trying to do a crosswalk of sorts. Look up a GL account number in one cell in an array and bring back a number from a specified column. Not having great luck with a vlookup. Can’t remember the exact rules (order, etc.) is there an easier way?

like

Anyone have experience with Excel on MS365? We have people using the same files and this version has no read only lock if someone else is using a file. Is there a check out option and if so, how?

like