Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-11-2023, 06:11 PM
Moondoggy Moondoggy is offline Menu Macro Not Executing - Need Help Windows 10 Menu Macro Not Executing - Need Help Office 2016
Novice
Menu Macro Not Executing - Need Help
 
Join Date: Dec 2015
Location: Pace, Florida USA
Posts: 21
Moondoggy is on a distinguished road
Default Menu Macro Not Executing - Need Help

Over the weekend I upgraded my PC to Microsoft 365 from Office 2016 and now I'm having an issue with a menu macro that is no longer working. Here's the issues:





A spreadsheet that was given to me by a trusted friend has a macro called DisplayMenu. There are supposed to be two ways to invoke the macro. The first method is to press CTRL+m. The second method is to click on an icon in the Quick Access Toolbar. If I press CTRL+m the menu does not appear but the letter m is shown in whatever cell I happen to be in at the time. The option to press the icon on the toolbar doesn't work because the icon does not appear in the toolbar. If I go into into Developer within Excel, click on Macros, I can see the DisplayMenu macro and I when I run the macro it works just fine so it's not the macro itself that's the issue it's something else. Two things that I've done are (1) I I opened File-Options-Trust Center- Trust Center Settings and verified that Macro's are enabled and (2) I opened the properties of the application icon and verified that macros are enabled and trusted there as well. So, at this point, I'm unaware of what to do next to try to get the menu to show up with CTRL+m and to get the icon on the tool bar to show up. Can anyone explain what I need to do to get this to work correctly on my PC?
Reply With Quote
  #2  
Old 01-12-2023, 04:13 PM
Moondoggy Moondoggy is offline Menu Macro Not Executing - Need Help Windows 10 Menu Macro Not Executing - Need Help Office 2016
Novice
Menu Macro Not Executing - Need Help
 
Join Date: Dec 2015
Location: Pace, Florida USA
Posts: 21
Moondoggy is on a distinguished road
Default

I'm closing this query. The icon that I thought was missing was really present but the author of the spreadsheet used an icon that looked like a decision chart and the location was not where I thought it should be. The problem with the CTRL+m turned out to be a intermittent malfunction of the CRTL key on the left side of the keyboard so I've ordered a replacement keyboard which should resolve the issue. The right CTRL key worked just fine
Reply With Quote
  #3  
Old 01-13-2023, 12:47 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Menu Macro Not Executing - Need Help Windows 10 Menu Macro Not Executing - Need Help Office 2021
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

Please mark as "solved" Thx ( see under "Thread tools")
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
  #4  
Old 01-13-2023, 08:29 AM
Moondoggy Moondoggy is offline Menu Macro Not Executing - Need Help Windows 10 Menu Macro Not Executing - Need Help Office 2016
Novice
Menu Macro Not Executing - Need Help
 
Join Date: Dec 2015
Location: Pace, Florida USA
Posts: 21
Moondoggy is on a distinguished road
Default

Quote:
Originally Posted by Pecoflyer View Post
Please mark as "solved" Thx ( see under "Thread tools")
I would like to but I examined the post and can't find any button or check box to do so. Can you enlighten me on how to do this?
Reply With Quote
  #5  
Old 01-14-2023, 12:49 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Menu Macro Not Executing - Need Help Windows 10 Menu Macro Not Executing - Need Help Office 2021
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

Click the Thread Tools button in the right upper corner just above your first post
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Executing a Word macro only after a certain date & time rdross51 Word VBA 4 07-07-2017 06:29 AM
Menu Macro Not Executing - Need Help Executing SAPI.cpl Quintuplet4 Word VBA 3 04-30-2017 03:47 PM
Executing a userform with a command button spc94 Word VBA 2 06-24-2015 10:08 PM
Menu Macro Not Executing - Need Help Shift Excel Cell after executing a macro for second time LearningMacro Excel Programming 2 01-08-2015 03:05 PM
Adding Macro menu to the right click menu (Word 2007) masam123 Word 0 10-14-2011 04:05 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:13 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft