Excel For Mac Developer Grayed Out
Open Excel for Mac. Click the Excel tab at the top of the screen. Choose the Preferences option. Veho vfs 004 driver for mac free. Select the Ribbon & Toolbar option. Check the box to the left of Developer in the right column. Click the Save button. My 'controls' option is grayed out in the 'developer' tab. This a blank, non-protected worksheet. I have also enabled controls within the active x. Ycm has dropped support for python2.
i have tried everything, but i cannot get my create button in Macros to ungrey itself, i changed the security settings as well with no change. Subscribe for Weekly Excel Tips and TricksHelpful tutorials delivered to your email!Similar TopicsHello everyone!!!! Here is my situation. I have been trying to learn macros but have not made one yet. Need your help. Here at work, I have some incompentant computer workers who claim they KNOW MS sooo well and have certificates etc.. *COUGH COUGH* ya ok.. LMAO We have a 'shared' work book we all work in. It's nothing fancy, just use it as a PO Book but since it is shared some people continue to not save before they add in more work so that they see a 'refreshed' copy of the workbook before they start writing in cells that already contain information. How to I create a macro button at the top of the page that is literally a SAVE button. instead of them saving by going to File - Save or cntrl+s ??? I just thought that MAYBE having a big button in their face will remind them. Secondly as back up I was wondering if you can create a macro to do a refresh of everyones screens automatically - say every 2 or 5 mins??? I don't mean a save.. but a refresh so the screen actually updates in front of you. (although I will keep this little piece of magic out of their knowledge so they don't rely on it, just though it would be a secondary back up to helping eliminate these mishaps cause we are loosing alot of information by people saving overtop of other peoples work and not caring.) Thanks so much!!!!! Muchly appriciated. Hi All, I got the below macro which uses IE and open the URLs. I want to create a userform with listbox with radio button and commandbutton on the same which will help me to connect to each url when I select the same in listbox and click on the commandbutton. Code: Any suggestions. I'm having a problem in a workbook with several ActiveX command buttons. I had been using the form control buttons to run macros, but the boss wanted each button to have it's own, different color. So I removed the form control buttons and created new ActiveX command buttons. I got into the button properties and set the background colors. I added the _Click code to run the macros when the user clicked the buttons. All of the buttons were working fine. Then I saved and closed the workbook and went to lunch. Now when I open the workbook, the buttons don't work! When I click them nothing happens. They appear frozen. They don't even seem to click. No error message. Nothing. If I right-click the button in Design Mode and select Properties, I get sheet properties not the button properties. I can't seem to locate the command button properties any longer. I still see the button name 'cmdButtonGetInfo' and '=EMBED('Forms.CommandButton.1',') in the name box and formula bar. The odd thing is if I create a new button it works fine until I save and close the file. When I reopen the file none of the buttons work. It's like the buttons are being disabled when I close or open the file. Any suggestions?
There sure is..Here's how: From the Excel main menu: <data><group and outline><settings> Uncheck: Summary rows below detail Does that help? *********** Regards, Ron XL2002, WinXP 'JMSprout' wrote: > When you highlight rows, go to Data, then Group or Outline, then Group, it > creates a nice plus/minus expand/collapse box for that group, only when the > group is expanded the button to collapse it is at the bottom row of the > group. Is there a way to get this button located at the top row of the group? i want to create two buttons within a workbook that adds (+1) to a value in a cell and one that subtracts (-1) the value in the same cell, i have been told that macros do this but i do not know enough knowledge about macros to configure it. can anyone help me please Some time ago I created a spreadsheet and greyed out the areas that weren't needed. Now I need to expand the spreadsheet and use more columns. Trouble is I've forgotten how to unhide those columns. I didn't write any macros and usings the right-click unhide method is proven futile. The sheet isn't protected which is puzzling since I can't get the mouse to even highlight any of the greyed out areas. Any suggestions would be fantastic! thanks I have protected a worksheet as it has several formulae on that I do not wat anyone else to mistakingly delete. I then have spent time on setting up a sheet to track changes (just in case this has any bearing on the problem). This is the only thing that I think I have changed since protecting this morning and now I cannot unprotect the sheet. I have not protected the workbook and the unprotect sheet function is now greyed out. Any ideas?
How to create a userform that will have button for search, edit, change, delete individual recordings. Also in case of listed results obtained records that could be printed? Thanks I added a print button to my userform Code: This prints out the userform as I would like, however it autoprints to the default printer and doesn't allow any printing options so I can't select to 'print to one page'. So as of now it is only printing out half my form and cutting off the rest. Any suggestions?
I have a excel spreedsheet that contain external data. I would like to put a button in the excel sheet to update the sheet without doing right click and refresh. My user here are very dummies. Hi guys, I was wondering if it is possible to change the color of a command button after it's been clicked? This is to allow the user to identify which buttons have already been clicked. Thanks!
I run a small business. I want to start keeping track of inventory using a barcode system. I know Excel 'ok', but I don't know programming.' I'd like to be able to do something very simple (for now).. For example..if I had PRODUCT / CODE / INV VALUE A - CODE A - 5 B - CODE B - 11 C - CODE C - 14 I would want to be able to click a button (or scan a code for) : ADD +1 or REMOVE -1 ..then scan the barcode on the product (A) and have it add or remove one, respectively. So, if the row for A is: A - CODE A - 5 I choose 'ADD' (with a button or scan code), then scan the barcode, and the spreadsheet automatically finds the code in the sheet, and changes the corresponding inventory value: A - CODE A - 6 Does that make sense? How might I go about doing that?
Hi all, the title pretty much says it all, I have a form where I am trying to create a button that will pop up a window where the user will browse to the desired folder and once that folder is selected, the path will be copied as a text string into the cell adjacent. My command Button cell is in B3 and the path should be shown in C3. Can anyone help? Thanks I have an excel form, I want my users to be able to open the form, fill in appropriate data, then click the save button. When the button is clicked, the data in the form should be saved to a new file and then the original form should be reset (clear all values) for a new set of data entry. When the data is saved, I want the new excel sheet to be saved to a location specified within the macro so the user doesn't have any options and I want the title of the new file to be the value of one of the cells. I'm new to macros and would appreciate any help this board can offer. Thanks.. Seemingly super simple, but I can't figure it out. When I create a bar chart, the bars are horizontal. I want the chart bars to be vertical. It tried to rotate the chart so that it is vertical, but the 'rotate' options are greyed out. How do I get those bars vertical? I suddenly see that parts of my sheet has been greyed out without me having consciously done it. How do I make sheet printable again?
I have searched and read all the help files. I find the properties of an object, I see how I can 'lock', 'size and move with cells' or 'not move with cells'. No matter what I select, the object moves off the screen, when the user, scrolls to the right of the spreadsheet. Is there a way to lock the position, let's say , in the upper right corner and have it stay there? This would be quite useful for an EXIT button, that I have created, that will close the program without saving (it's a read-only file.) Thanks to all the wonderful people here that have been so helpful and give us their valuable insight and time. Jo
Hi everyone, I found an excellent macro this morning that allows the user to filter a pivot table based on the value found in a specific cell. This cell essentially acts as a search bar, allowing the user to type in what they are looking for rather than select it from a drop-down list. The macro works perfectly for my purposes except in one regard: I can no longer perform a 'show all' filter. If I leave the 'search bar' cell blank, the pivot table shows nothing. I'm sure that there is an easy fix for this but I'm still learning the basics of how to write and use macros. How can I change the code so that when I leave the cell blank, the pivot table shows all? The search bar cell is D2. Thanks for your time!
Hi Excel experts, I am working on a worksheet, and would like to have an entire row transferred to another worksheet based upon a certain cell's value. Having searched through the many solved threads on this site, I attempted to customize some of the code to my worksheet. Not being proficient in Macro/VBA, I failed. I figured I would ask for help, and see if anyone can provide what I am looking for. Basically, I am attempting to construct a 'work in process' file, and would like all completed work to be deleted from the work in process sheet, and transferred to a sheet that contains a running list of all work completed. Attached is an example of what I am working on. I would like Column Q (Status) to determine if a row can be moved to a sheet that contains the list of all work completed, and eliminated from the original sheet. Once Status is updated to 'Complete', it would be helpful to be able to run a macro/click a button that would perform the transfer. Can anyone assist? Thanks!
hi, I have a login form with an Exit button. I want my workbook to close as I click Exit button.
How do I get the colors to change automatically when I use a drop down list. Per say here is what I am trying to do If a certain 'word' is used from the drop down list I want the background of that cell to change its color to 'green.' And if later I change the 'word' to another from the drop down list, it will change it's color to a specified color. The drop down list that I use was created from cells that have the colors already in the 'word', but I do not know how to make the list show the colors so it puts the word & color automatically in the drop down list to the cell with the drop down (if that makes any sense). If there is a way, please spell it out simple enough for me to understand, as I don't know fully the capabilities of formulas or vba.
I'm trying to come up with a solution to calculate the man hours and days worked over multiple sheets. I have a file that has 8 sheets. the first seven sheets are the days of the week and the 8th sheet is where I want to calculate the hours. The days of the week consists of 'Name' 'Date' Hours' The 8th sheet consists of 'Name', 'Days of the week in their own column (7 columns in total)', 'Total Hours' and 'Total Days Worked' Now.. each day is always a different group and what I'm hoping for is to create a formula that can grab each name with their hours and throw them into the 8th sheet. So when the end of the week is done I have all the Employees weekly hours and days worked all finished. I hope this makes sense. This file is to track about 100 employees that are on a rotational work schedule. I have attached a sample file. Thanks in advance for your help. Good afternoon! I'm working with Excel 2003 sp 3 on Windows xp. I have been banging my head trying to jar loose the formula to calculate man days where 1 equals 8 hours. I have one that was given to me by a coworker: =INT(Q3/8)+(((Q3/8)-(INT(Q3/8)))*0.8) That calculates man days from total hours. I need a formula that will total man days and return the man day answer. Example: weekending 12/25 = 16.2 which is 16 man days and 2 hours weekending 1/1 = 24.7 which is 24 man days and 7 hours Total = 41 man days and 1 hour I have also been asked if there was a way for a number to be entered into a spreadsheet and automatically put in order without a macro or 'pushing a button'. Any advice is greatly appreciated! Happy New Year! ~ Brenda ~ Is it possible to share a workbook with macros and have the macros work properly. I have one spreadsheet that needs to be shared by many users. We want to all be in the same document at the same time saving changes. The real catch is that the workbook has macros. I used the 'Share Workbook' function under tools. At the end of the setup, it told me that the macros would not work properly. The odd thing is that everytime I try to click on one of the macros I get an error, but yet the macro still performs the function. So essentially the macro works, it is just a pain because you have to click 'end' everytime on the error screen. Any suggestions? Alanda
Also, I cannot move the Pivot Table from the new Worksheet it is created in, to my existing Worksheet. I am running Excel 2011 for Mac. I have a Worksheet with a small amount of data, and when I click the Pivot Table button it automatically creates the Pivot Table in a new Worksheet. The Pivot Table data is fine, but I want it to display alongside the source data. I've tried using the Move Pivot Table option and choosing to Create Pivot Table in Existing Worksheet and choosing a source cell alongside my current data, but nothing appears. Also, I checked in Edit menu and found that the Pivot Table appears to have not even been created/moved because there is no option to undo it. Appreciate any help, let me know if you have any further questions. Hunter |
Hi all,
I have searched Google throughout and found similar but not problems.
Version: Excel 2010
I created a spreadsheet with macros and ActiveX buttons on the page that call these macros. I also have an ActiveX Textbox in the sheet as well. Up until a few days ago, everything was working fine. Now when I open the spreadsheet, all of the ActiveX controls have disappeared and the 'Insert' button to add ActiveX & Form controls in the Developer tab is greyed out?? Also, I have some cells with Data Validation on them using a list and I cannot see or get a drop down list to appear (even with Alt + Down). Also, when I enter a value that is in the data validation list, it says that the data I've entered is invalid. Something bizarre is happening.
Does anyone know what's going on here? I believe that the controls are all still there, just being blocked by something (I don't think it's the visibility property - this wouldn't affect the Insert button!) PS. I have enabled macros when the macro security thing pops up when you open the sheet and I can still run macros.
Thanks in advance!
Nick