I created a macro to help me save time on this onetime task and now whenever I open my excel, a blank excel opens with the name of the macro. How do I get rid of it?

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

Probably not related, but I had the same issue with a time sheet I was saving on my desktop, that was linked to the company OneDrive. I didn’t realize I wasn’t logged in to the OneDrive and once I did it stopped.

Following for future reference.

This sounds like a problem that people run into when they create macros for Personal.xlsb. I did a bit of searching on "Excel personal keeps loading" and found this solution on the Microsoft forums. I haven't tried it, but I think it would work for you.

On your macro workbook, open the View ribbon and click Hide. Hide is in the Window sub-ribbon, a bit to the right of the View button you would have just clicked. Close Excel, and if Excel asks you to save the changes, click yes.

Related Posts

What is the leave policy in JP Morgan?

like

When do you think is the right time to take your side gig and make it your main gig?

like
likehelpful

Any body have to take a month off work to go to rehab then return? With a threat that most likely your current account will be handled by someone else and suffering lack of confidence maybe even fired

Should I do the PMC at the Product school? Does it help when transitioning to product?

like

Did anyone attend the Salesforce world tour in London today?

Does oracle has a office at Kolkata ? My current location is banglore , can I change my base location to Kolkata ?

If yes , what's the process ?

like

Anyone prepping for the SHRM-CP test? I’m taking a prep course this fall and would love tips or to know if there are any study groups out there!

like

McKinsey & Company Strategy& people are getting a $4500 special recognition bonus on top of the annual bonus!🤑

How are y’all firms doing?

Boston Consulting Group McKinsey & Company Kearney Oliver Wyman Roland Berger

like

Happy Monday!
I have an interview with KPMG for Senior Associate role in NYC. Do you know what’s the average salary under strategy?

Thank you!

like
funny
likeuplifting

Is McK Digital less brutal in terms of hours but the same level of prestige as general McK?

like

Package/CTC question - Hi Sharks, I am a in grown manager and believe the HRs that I have dealt with till date have lowballed me. CURRENT - Site BLR. CTC ~ 11.0 L. 5 RSUs. L4 Manager. Operations. Non tech. I believe it should be around 16L. Am I correct? Can ya'll help with the range of Pay for L4 Managers along with RSUs and joining bonuses.???

like

What is the usual starting comp for Staff Data Engineers (SDE 3) at Facebook and Amazon?

like

My boss in my creative agency threatened to fire me because I, a male, came into work with my nails painted. HR is having a very complicated day today as I found out I could take legal action if he does fire me since we don't have an established dress code that has any guidelines against male nail polish wearing.

like

Thoughts on the best domestic mileage program? Any recommendations for someone also potentially using those miles for international redemptions?

like

Can someone refer me urgent
15YOE in IT Operation, Immediate Joining..

like

Additional Posts in Excel Genius

I’m verrrrrry new to excel and am going crazy because is there not a way to “clip” text in cells like you can in google sheets? I read about a “fill” option, but then noticed that cells that aren’t filled just repeat text. 😂🤯

like

Recently made a job switch and have been using a lot more excel. Any free resources to help build a solid foundation / fee based courses to help improve my skills?

like

What’s the keyboard shortcut to get into the “insert options” dialogue when you’ve inserted a new row with Ctrl+Shift+Plus?

like

How do I look up values from a column in a row? E.g. Values in A1:A6 in B2:F2?

like

Hi All,
Looking to automate a manual process for the client and thinking of creating macros for with VBA. Has anyone done anything similar?

In the process of learning but wanted to reach out for any tips, tricks and advice anyone may have.

Thanks I’m advance.

like

Client sent over a 90 MB model this evening. Took 10 minutes to open and a fraction of that to crash. Can’t wait for tomorrow 😭

like

How can I extract just the year into a new cell from a “yyyymmdd” cell (labeled PD here) that isn’t recognized as a date? I basically need to sort this data by year. Thanks in advance!

Post Photo
like

Has anyone had an issue with index match and lookups returning NA when trying to manipulate data from a password protected workbook?

I’m helping my GF with excel and need help lol. She works at a hospital and is trying to make an excel schedule for doctors to reserve rooms. She wants drop downs for days of the week (column K) and also different drop down menus in column P for the reserved time slots.

Is it possible to do this with two sets of drop downs (days of week + time slots) and not use index match here? She could make 5 tables for each day of the week, but prefers one table that can be easily navigated by doctors.

Post Photo
like

Vlook up isn't recognizing a couple of cells even though it's feeding off a pivot and when I check with an " if =" it comes up as being the same.
Any advice on what I need to check?
Thanks

like

Best free data sites to tap into to build a city analysis model? Basically I want to "discover" cities with certain dimensions, like: population, elevation, climate, and proximity to other things (ski resorts, particularly)?

like

What are your top Excel ninja tricks? Ones that few people know...

like

Timesaver: If you’re working on a file saved on the cloud (teams, share point, etc.) and need the URL to communicate out, tap FILE -> INFO -> COPY PATH and the url will be on your clipboard. Pre-established sharing privileges of orig folder will apply. Hopefully this saves you time reshuffling open windows! Bonus: Same on standard MS suite files.

likesmart

Anyone else have a formatting pet peeve and get annoyed when people don’t have a blank first column and row in tabs? I.e headers/data in cell A1

My first manager told me this, and I’ve followed it to a T since.

likesmart

This is dumb, but. How can I pull and average the numbers in column b associated with the 4 values in column a? So, (sum of all As/total number of As) without filtering?

Post Photo
like

How can I add multiple characteristics within one cell and make sure that a pivot table can read both values independently if needed? E.g., I have a column titled “color” and in one cell I write “red” and the other “red, blue”. I’d like a pivot table / formula to be able to count that there are technically two “reds” in this data set. Any tips?

like

Need help building an electric schedule for a production schedule with a Gantt chart style view (sort of)

Currently have an excel list with resource (production line), start date and time, and then also the name of the item being produced.

Any ideas how to tackle this??

I’m thinking a stacked bar chart with the vertical categories to be my resources and horizontal the date/time and then each individual bar to be the name of the item being produced.

Thank you for the help Excel Gods 🙏

like

Is there anything similar to the INDIRECT function that I can use to build a formula reference to another workbook? INDIRECT creates errors when the referenced workbook is closed..

like

Would anyone be willing to teach me vlookup?

like

New to Fishbowl?

Download the Fishbowl app to
unlock all discussions on Fishbowl.
That was just a preview…
Sign Up to see all discussions
  • Discover what it’s like to work at companies from real professionals
  • Get candid advice from people in your field in a safe space
  • Chat and network with other professionals in your field
Sign up in seconds to unlock all discussions on Fishbowl.

Already a user?
Login here

Share

Embed this post

Copy and paste embed code on your site

Preview

Download the
Fishbowl app

See what’s happening in your industry
from the palm of your hand.

A phone with Fishbowl app

Scan your QR code to download
Fishbowl app on your mobile

Download app

Sign up for free to view this conversation on Fishbowl

By continuing you agree to Terms of Use and Privacy Policy

Already have an account? Log in

Sign up for free to continue using Fishbowl

By continuing you agree to Terms of Use(New) and Privacy Policy(New)
Messaging rates may apply

Already have an account? Log in

For account settings, visit Fishbowl on Desktop Browser or

General

Legal