#1
|
|||
|
|||
Means to easily run Macro from BOTH Windows and MacOS
Hello!
I have a Macro that is already completed but I need a method to run the macro with something as simple as a click of a button from BOTH Windows and MacOS. I originally had a button that could be clicked but Mac does not support activeX controls so the button does not work. I also tried mapping a hotkey but that does not translate over to Mac either... I thought of trying to figure out how to have the macro automatically run when text is pasted into the document but couldn't find a solution for that so I am kinda stuck... Short of having two different forms, one for MacOS and one for Windows, any ideas? |
#2
|
||||
|
||||
Does a MacroButton field work on a Mac?
__________________
Andrew Lockton Chrysalis Design, Melbourne Australia |
#3
|
|||
|
|||
Macro buttons in Word for Windows use ActiveX, which does not work on MacOS... MacOS has it's own button option but that does not work on Windows.
|
#4
|
||||
|
||||
MACRUTTON fields don't use ActiveX and are supported on Macs. See: Word for Mac 2016 - Picture in MacroButton field doesn't trigger macro
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#5
|
|||
|
|||
My apologies, the only button fields I am familiar with for Windows that can be used with a Macro on Word are the ActiveX buttons. I am not sure I am understanding the link you sent...
*EDIT: Nevermind! I figured this out. Thank you! |
#6
|
|||
|
|||
@Macropod
Hello! So, this is still not working on a Mac. I tried it with an image first (on a .doc since it would actually run the macro on Windows rather than just selecting the image) which did not work, then I tried it with just text on a both a .doc and .docm and it still does not run the macro on MacOS... I've had several of my Tech team try it as well, and it would not work on a Mac. I am going to remote into one of their devices (we are all remote employees) to take a look later today to see if I can figure out WHY it would not be working. But the idea is that it has to be super simple because it will be used by many users and they need to just be able to open it and double click without having to reconfigure anything on their end. (Each user DOES already have Macros enabled). |
#7
|
||||
|
||||
Without actually seeing the problem document, it can be difficult for anyone to diagnose the issue. Can you attach a document to a post with some representative data (delete anything sensitive)? You do this via the paperclip symbol on the 'Go Advanced' tab at the bottom of this screen.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#8
|
|||
|
|||
I have attached the document. It is nothing too complicated, at this point it just does some required formatting.
|
#9
|
||||
|
||||
A macrobutton is not a physical button - it is a field. It displays as text and you can format it to give it background shading or make it stand out.
Paste the following line of text into your document MacroButton myMacroName Double click to make it so Change the myMacroName to the name of YOUR macro Select all that text and press Ctrl-F9 to convert it to a field. Then press F9 to make it display the result. Now you have a macrobutton field. Double click that text to run the macro.
__________________
Andrew Lockton Chrysalis Design, Melbourne Australia |
#10
|
||||
|
||||
There is no MACROBUTTON field, or VBA code in your document.
Andrew has given some advice about the former. See attached implementation.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#11
|
|||
|
|||
@Guessed - Yes, I am aware it's not a button! On my sheet I simply formatted the text to look like more like a button and I have already done all that in the spreadsheet I uploaded.
@Macropod - The document I uploaded absolutely has a macro in if and already has a the macrobutton field implemented. See the screenshots attached. I have no idea why when you downloaded it, you cannot see them... I have also reattached the document itself. Also, I redownloaded the one I uploaded here first and it works fine for me and shows the macro... |
#12
|
|||
|
|||
Your screenshots clearly show that the code is in your Normal template, not the document named Formatter
|
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
word for Mac unable to format or print documents after upgrade to macOS Big Sur | Gerben | Word | 0 | 11-28-2020 06:28 AM |
macOS Digital signature in excel | ki_ha1984 | Excel | 0 | 10-05-2019 05:31 AM |
Macro works in Windows XP but not in Windows 7 | Baldeagle | Word VBA | 3 | 09-30-2013 03:56 AM |
Effective means of practice powerpoint | powerpointD | PowerPoint | 0 | 10-01-2012 04:02 PM |
what + (plus) means in word? | rus2uk_office | Word | 0 | 07-07-2009 10:30 AM |