I want to create a macro, but i have no Developer tab (recently got Microsoft 365).
Googled how to add it, but it says to go to FILE select OPTIONS and then select CUSTOMIZE RIBBON then select DEVELOPER.
But after go to OPTIONS and select that, I get no menu; just goes back to the spreadsheet.
That is the right way: Click File--> Options --> Customize ribbon --> Put Checkmark in developer
Last edited by HansDouwe; 07-29-2023 at 02:20 PM.
Yeah. Those are the instructions I got when I Googled this, but when I click FILE and then OPTIONS I don't get those menus. It just reverts to the Spreadsheet.
After you click File and options Customize Ribbon is here:
You could also try right clicking any of the ribbon headers and selecting "Customize Ribbon" from there.
BSB
I've tried that too. I right click a tab in the ribbon and the click on CUSTOMIZE RIBBON in the drop down. The drop down disappears, but no other options appear.
Does pressing the Mac alternative to Alt+F11 open the VBA window for you?
Opt + F11 or Fn + Opt + F11?
BSB
For Mac see here:
It's not a Mac.
The confusion there lies because your profile shows you're using "Excel for Mac"!
JUst press Alt+F11, does that open the VBA window?
BSB
Administrative note
Is your forum profile showing the Excel PRODUCT that you need this request to work with?
The best solutions often rely on knowing WHICH Office PRODUCT (Excel, NOT Windows) that you have. Please check that your forum profile is up-to-date. If you aren't sure, in Excel go to File/Account and report what it says below the MS logo at the top of that page. If your version is for Mac, please also state this.
The three most recent Excel PRODUCTS are Excel 2019, Excel 2021 and MS365 - if you are using MS365, please give this name along with the Version number in your profile (e.g. MS365 (PC) Version 2211). The version number is in the About Excel section further down the Account page.
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
Thanks. I was using Mac until a few months ago. I will make that change. Thanks again.
So did Alt+F11 work for you?
BSB
Microsoft 365 for PC
Microsoft 365 Version 2307 (Build 16626.20068) for PC
No. It did not.
You may want to try uninstalling and reinstalling Excel then. Sounds like an iffy install to me.
BSB
May be is your Excel file protected. Please start with a new empty Excel-file and then try again.
Tried a new blank worksheet with the same result.
tried a new blank worksheet with the same result.
I definitely do not WANT to uninstall and reinstalll, but that does seem to be the next logical step. I hope it goes better than other things have recently. Thanks.
Are you on your personal computer or your company's computer. Read the following to understand why I ask.
https://answers.microsoft.com/en-us/...e-ff92001ae272
@ WWgolfer, What happens when you hold down the 'alt' key and press the 'F' key followed by the 'T' key ... ie Alt+F+T
Sounds like your office install is corrupted. Recommend reinstall.
It did not.
Have seen Alan's post (#22) above?
If you're on a work computer it could be your IT bods are limiting access to it...
BSB
No. It's smy personal computer at home.
Then if a reinstall hasn't helped, I'm out of ideas and consulting my crystal ball I can see a conversation with Microsoft in your near future...
Sorry!
BSB
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks