How do I enter design mode on Excel Mac 2011? It does not appear in the developer tab.
I am trying to create a button on a worksheet to open a user form, and all the instructions I can find on how to do this require entering the design mode and double clicking on the button to enter the code.
i dont think excel 2011 for mac has active x controls hence no design mode, have you tried using one of the form control buttons then assigning code to that to open the user form
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
Never touched a Mac, but there's also a design mode button on the VBE standard toolbar on PC.
EDIT: I think Martin's right.
Entia non sunt multiplicanda sine necessitate
image of mac 2011 developer toolbar
http://excelsemipro.com/wp-content/u...-Developer.jpg
no active x there
So if there is no design mode, where would I enter code for the button to make it open a user form? The button is located on a worksheet (not on another userform).
Right-click the button, Assign Macro
Hi,
On my copy the Developer tab sits on a single row starting with 'Home' which is between the custom menu bar icons and the Ribbon icons.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Shg, userform does not appear in the list, only modules.
Richard, Design Mode does not appear in the developer tab in Excel Mac 2011 (see Martins post).
Here is a video for that
http://www.youtube.com/watch?v=jCzdTdYxGmY
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
On the Developer tab. Click the control you want from the ribbon, click on the sheet where you want it to appear.
Mac Excel moves intuitively between Design mode and non-Design
_
...How to Cross-post politely...
..Wrap code by selecting the code and clicking the # or read this. Thank you.
well i never!
In not sure if I did I correctly but I found a work around. Since the Userform was not appearing in the Assign Macro window, I just created a Module that runs the userform and assigned that to the button.
@nitefoxOriginally Posted by Nitefox
I wasn't implying that it does. As a sometime Excel for Mac user (when it can't be avoided!) I know only too well that Design Mode with the option to pick either Forms controls or Activex Controls doesn't exist and you can't add activex controls on a worksheet. See http://support.microsoft.com/kb/274222
I had assumed the OP was asking how a forms control button could be added and wasn't sure where to find it.
As you have rightly commented the only way is to link a button to a module level procedure which runs the UserForm
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks