By Geetesh Bajaj, James Gordon. In Office 2011 for Mac, Excel has a special kind of sheet called a dialog sheet, on which you can make an input form such as the one you see when you’re in an Excel 2011 for Mac table and choose Data→Form. When I save the file in Mac OS Plain Text Format, it's greyed out in the Excel Run Saved Query dialog, and can't be selected. I haven't found a way to save in MS-DOS format from Pages or TextEdit, but it's easy enough to do in Word for Mac 2011. My queries work fine without the.iqy suffix described at dummies.com.
I'm trying to create a very user friendly form for a team of mental health workers, who are not tech savvy. Essentially, it's a progress note that is filled out after each session. I'd like for the template to carry over to the next sheet and be named the date of session that the therapist enters in a particular cell. Rather than copying and pasting the form on multiple sheets, I'd like the user to be able to hit a button that brings up a new sheet, which will be automatically named 'mm-dd-yy' as soon as she enters that information (which will hopefully be via a date picker.) As each session gets its own note (and sheet), I'd also like to have the 'Session #' cell be automatically populated - sequentially.
I mentioned that the therapists are not tech savvy, but I am not an expert by any means, so I struggle with understanding code writing. I'm using Excel 2011 for Mac. You're my only hope, Obi Wan.
See solution in other versions of Excel:. Question: In Microsoft Excel 2011 for Mac, how do I get the Developer tab to display in the toolbar at the top of the screen? The Developer tab is the toolbar that has the buttons to open the VBA editor and create Form/ActiveX Controls like buttons, checkboxes, etc. Answer: To display the Developer tab, click on the Preferences under the Excel menu at the top of the screen. When the Excel Preferences window appears, click on the Ribbon icon in the Sharing and Privacy section. In the Customize section, check Developer in the list of tabs to show. Then click on the OK button.
Now you should see the Developer tab in the toolbar at the top of the screen. All of the Developer tab option groups should be available - Visual Basic, Add-Ins, and Form Controls (see below).