Forums
New posts
Articles
Product Reviews
Policies
FAQ
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Menu
Log in
Register
Install the app
Install
Forums
General Discussions
Switcher Hangout (Windows to Mac)
Excel VBA Command Button doesn't look quite right...
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Reply to thread
Message
<blockquote data-quote="GrahameCoyle" data-source="post: 1742231" data-attributes="member: 386959"><p>Hi</p><p></p><p>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.</p><p></p><p>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.</p><p></p><p>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.</p><p></p><p>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?</p><p></p><p>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.</p><p></p><p>Any help / suggestions warmly welcomed!</p><p></p><p>It's my first post, and I'm a lifelong Windows user (...insert pity here...), so please be gentle with me...</p><p></p><p>Thanks,</p><p></p><p>Grahame</p></blockquote><p></p>
[QUOTE="GrahameCoyle, post: 1742231, member: 386959"] 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 [/QUOTE]
Verification
Post reply
Forums
General Discussions
Switcher Hangout (Windows to Mac)
Excel VBA Command Button doesn't look quite right...
Top