Nov 23, 2010 I just installed PowerPivot x86 version for 32 bit Windows 7 with Office 2010. The install went fine but when I open Excel I can see PowerPivot on the ribbon but all the options. Excel Insert Button Greyed Out? 5 Solutions (with Images) What is it. Insert button under Developer tab helps you insert Form Controls and ActiveX Controls like Combo Box, List Box, Spin Button etc on your User Form or Excel worksheet.
Subscribe for Weekly Excel Tips and TricksHelpful tutorials delivered to your email!Similar Topics
Hi guys,
Looking for some help and would appreciate your help. I want to prevent people cutting/copy/pasting on a spreadsheet I have developed. A couple of users keep doing so which in turn knackers my formulas. There will be occasions where I will need to be able to use these functions for maintenance and updates. Ideally I would like have a private marcro which I can run to enable these features as and when needed. I've been at this all morning and feel like I'm going round in circles. I've tried various bits of code (sourced via google etc) & have ended up with a whole manner of outcomes but not the one I want. To summaraise what I am looking for is some vba code which will do the followingDisable cut,copy and paste when sheet is openedEnable cut,copy and paste when closedHave a macro which when run will allow me to cut/copy paste so as to implement updates when necessary. Can anyone help? Thanks in advance
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 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 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?
I have excel sheets that cross link with each other. I've just migrated to Office 2007. When I open my excel sheet I always get the question at the bottom of the tool bar Security Warning Data connections have been disabled. And then I have to click on option and enable content.
My question is, how do I always enable the content? Thanx
I was testing the following methods (suggested in another thread) to disable copy/paste on a particular worksheet -- now copy and paste is disabled entirely from Excel and, apparently, from each and every excel workbook I've got. HELP!!!!!
http://www.xcelfiles.com/VBA_Quick13.html http://www.mrexcel.com/archive2/75500/87639.htm Taxstar
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?
Hi
I need to disable all kinds of messages that could appear in front of the user when it opens the workbook. I am already using DisplayAlerts=False and On Error Resume Next? Can we also do this through excel application itself and not using VBA ?
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
I am using the code below to disable the save function very successafully. However, is there a work around to allow a macro to save?
---------------------------------------------------------------------- Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean) 'this disables the save function on the XLS MsgBox '****Save is Disabled****' ' Following line will prevent all saving Cancel = True ' Following line will prevent the Save As Dialog box from showing If SaveAsUI Then SaveAsUI = False End Sub
Hi
I am using Excel 2007 and suddenly I can no longer filter by color. The option is greyed out and so is the sort by Color option. Does anyone have any idea why this would happen? Thanks in advance.
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...
I am setting up a PivotTable and only want to show the actual raw data values in the PivotTable field and NOT any sum, count, average, max, min, etc etc.
How can I do this? I only seem to have the options for sums, counts, etc. There are no options for just presenting the data. So for example, rather than a PivotTable that results in counts of 1, 1, 1 in each cell, I want it to show Compay1, Company2, Company3, etc.
I've lost my menu bar in Excel. I tried to enable Worksheet Menu bar, but
that is not even listed in my toolbar section in the Customize box. Any other ideas?
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
Hi everyone
I need some help in this: In a excel workbook when I copy a worksheet (to duplicate with other name) there is always a name conflict and so I have to say yes (maintain the name) or say no (and excel ask for other names) many times (sometimes more than 50 times pressing the enter button. Its possible to disable this feature? My best regards and Thanks in advance. Melnik Kuhn
Dear All,
I have around 250 Employees Payroll and i am preparing the Payslip in Excell manully. I have all the Salary details in Sheet1 and in Sheet2 is Payslip. I request all of you to please help me so that i can take the printout of all the employees in sheet1 by at a time. Now im entering one by one employees code and then taking the prinout.. Please provide me with any Formulas as micros are disable in my Computer..... Waiting for an early reply.......
I have an Excel workbook that was created by a former coworker. It includes a macro that, among other things, displays a message box about the 2008 file. The macro runs as soon as the file is opened. I'd like to access that macro to correct the date to 2011 and see what else, if anything, it's doing for me (it doesn't appear to do much). I can find references to creating macros to hide and unhide rows/columns and I found ways to delete all macros in a workbook, but I cannot find anything about unhiding a macro without knowing its name.
Does anyone know of a way to unhide this macro? Thanks!
I have a sheet with a list of names on and I've noticed that when I use ctrl+F to use the find function, even when I know i have entered the correct name it still will not work. I have identifed times when I know the name is there on the sheet, but the find function says 'Excel cannot find the data you are searching for'
Im unable to put any pics up as my work pc has java disable so photobucket ect won't work but has anyone else come across this problem and how did you rectify it? A search macro perhaps?
Hi Guys,
Could you be so kind as to provide some code that will enable me to display a text box on a userform rounded up to 1 decimal place. Where am I going wrong.... it calculates the number entered in textbox1 and divides it by a value that changes in cell O26 but the answer is in about 8 or more decimel places. Only need like 65.3 as an answer not 65.277756942 This is the code ive used. Private Sub CommandButton1_Click() TextBox2.Value = Val(TextBox1.Value) / Range('O26').Value End Sub
Hello,
i've got the following problem: I want users to double-click on a row on a protected sheet and then do some code based on the row-number of the clicked cell. I've protected the sheet because it contains a lot of formula's. When a user double-clicks a row it triggers the code through the Workbook_SheetBeforeDoubleClick event. After the code is executed Excel shows a message that the cell that was clicked was protected etc etc. How can I prevent this message from popping up? I've already tried Code: but that didn't work Thanks
Hello,
As the title goes this is as simple as it gets. The macro worked good when I was using excel 2003 but now that I have 2007 everything works for except the resizing (Picture.Width & Picture. Height). Code: I have tried to record some macros while I am resizing the pictures but to no avail the macros are blank. Please help Thanks!
I need a set of formulas to list all 120 permutations of the letters ABCDE, can anyone help?!
I have the strangest problem... somehow, right clicking a cell doesn't
bring up a menu anymore. It happens only when I'm in Excel only... it still works even if I bring up macro editor within Excel... it only doesn't work when I'm in Excel. I've tried Options and Customize... nothing there seems to work... HELP!!!
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? |
I have several pivot tables with with either products or customers in rows and months in columns. Outside of the table, I have various calculations, 12 month trend, 3 month trend, current month compared to trends etc.
If I filter my row to a certain product that does not have data in all columns (months) the calculations outside the table to not work.
I went to PivotTable Options / Display and the 'Show Items with No Data on Rows and Columns' are both grayed out. Why and can I get this function to work?
I tried to attach a small file but it's saying it's too large to attach, sorry.
If I filter my row to a certain product that does not have data in all columns (months) the calculations outside the table to not work.
I went to PivotTable Options / Display and the 'Show Items with No Data on Rows and Columns' are both grayed out. Why and can I get this function to work?
I tried to attach a small file but it's saying it's too large to attach, sorry.