- Joined
- Dec 23, 2016
- Messages
- 2
- Reaction score
- 0
- Points
- 1
Hi
I have an Excel .xlsm workbook, originally created in Excel for Windows, and I'm now trying to port it across to Excel for Mac.
I'm using a Command Button on multiple sheets to trigger a VBA Macro (that inserts rows). The macro triggers fine when the .xlsm file is opened on the Mac, after accepting the prompt to allow macros to run etc. The only thing that I can't figure out is why the Command Button looks different.
In the original (Win) file, the Command Button is fitted neatly within a cell boundary. When I open the same file on the Mac, the button is slightly deformed, with the button text shows as being slightly separate/disassociated from the actual button. I can still click the button on the Mac, but it just looks bad.
Does anyone have any tips for how to make a Command Button cross-platform compatible, or suggestions for a cross-platform alternative way of triggering my VBA macro that will look consistent regardless of which OS is opening the file?
I don't want to create to different file versions as the workbook is quite substantial, and managing changes across two separate files would be less than ideal.
Any help / suggestions warmly welcomed!
It's my first post, and I'm a lifelong Windows user (...insert pity here...), so please be gentle with me...
Thanks,
Grahame
I have an Excel .xlsm workbook, originally created in Excel for Windows, and I'm now trying to port it across to Excel for Mac.
I'm using a Command Button on multiple sheets to trigger a VBA Macro (that inserts rows). The macro triggers fine when the .xlsm file is opened on the Mac, after accepting the prompt to allow macros to run etc. The only thing that I can't figure out is why the Command Button looks different.
In the original (Win) file, the Command Button is fitted neatly within a cell boundary. When I open the same file on the Mac, the button is slightly deformed, with the button text shows as being slightly separate/disassociated from the actual button. I can still click the button on the Mac, but it just looks bad.
Does anyone have any tips for how to make a Command Button cross-platform compatible, or suggestions for a cross-platform alternative way of triggering my VBA macro that will look consistent regardless of which OS is opening the file?
I don't want to create to different file versions as the workbook is quite substantial, and managing changes across two separate files would be less than ideal.
Any help / suggestions warmly welcomed!
It's my first post, and I'm a lifelong Windows user (...insert pity here...), so please be gentle with me...
Thanks,
Grahame