#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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
|
#3
|
||||
|
||||
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 |
#4
|
|||
|
|||
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?
|
#5
|
||||
|
||||
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 |
|
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 |
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 |
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 |