Audit Toolbar Items Greyed Out

Sep 22, 2006

I am using Excel 2000 on Windows 2000. There are no macros on spreadsheet and no protections at all yet I acnnot use trace precedents/dependents as the items are greyed out.

View 2 Replies


ADVERTISEMENT

How To Activate Greyed Out Ribbon Items?

Jan 2, 2009

I would like to restore some important functionality in Excel 2007 which has become disabled for a spreadsheet which I saved in different file formats.

I opened an Excel 2003 file with Excel 2007 and used 'Save As' into different formats (default, macro-enabled, binary) to see the resulting file size.

A number of Ribbon items are now greyed out for this file, including,
- Insert - Tables, Illustrations, charts, etc.
- Styles - conditional formatting and Format as table,
- Formula Auditing
- Data - just about all of them
- View - some of the Window items.
Also, I cannot resize or move a button on a worksheet.

Attempts to 'Save As' into the Excel 2003 format cause Excel 2007 to hang.

What caused so many features to become disabled?

How do I restore them?

View 6 Replies View Related

Items Greyed Out On Sheet Right Click Menu

Jul 11, 2007

I cannot figure out why this setting has changed. When I right click my tab worksheet in Excel to copy or rename, it does not allow me. I will need your advice to re-activate that options so it is visible and not gray. I tried in the VBA workbook properties settings with no luck and also Tools, Options.

View 6 Replies View Related

Forms Toolbar Versus Control Toolbox Toolbar

Oct 19, 2006

which of these toolbars provides the better 'controls' to paste onto worksheets (as opposed to UserForms)? For those wondering, both toolbars contain some apparently similar controls, e.g., combo box, radio button, spinner etc. but there are differences in their behaviour it would seem...

View 2 Replies View Related

Calculating A Number From Answers To An Audit

Dec 18, 2008

I have created a workbook that I store data from my audits, this data is in the form of Y if compliant, N if noncompliant and N/A if not applicable. Where the fun part begins is that each question has a different risk involved. I have used a simple 1 to 5 risk scores and given scores for compliance and non compliance to each score, for example a risk 1 if compliant is 100 points, if non compliant is -100 points, all the N/As are worth 0.

I currently calculate the totals in a different sheet in the work book, but I do this kind of manually, I have calculations to work out the totals and percentages and all that, but I cannot figure out how to get the Ys and Ns to appear in this sheet as 100 or -100. All I do at the moment is bring the Y, N or N/A over with a simple =corresponding cell in sheet 1 then manually change this to the number I require.

View 4 Replies View Related

Audit The Selection Of Players Selected

Mar 14, 2007

I have this macro and I would like to audit the selection of players selected. I would like the number that is entered in the input obx to be placed in the sheet "DRAFT" and be placed in A1 and the next in A2 and so on. Can this code be modified for this to occur.

Sub SearchDelete()
Dim ID, c As Range
ID = InputBox("Enter the Super10 Player ID Number", "Super10 Player Search")
If IsNumeric(ID) Then
With ActiveSheet.Range("a:a")
Set c = .Find(ID, LookIn:=xlValues)
If Cells(c.Row, 11).Value = "" Then
Msg = "P L A Y E R A L R E A D Y S E L E C T E D !" & vbCr & vbCr & "Player # : " & Cells(c.Row, 1).Value & vbCr & "Name : " & Cells(c.Row, 4).Value & vbCr & "Games : " & Cells(c.Row, 6).Value & vbCr & "Average : " & Cells(c.Row, 7).Value & vbCr & "Position : " & Cells(c.Row, 2).Value & vbCr & "Team : " & Cells(c.Row, 3).Value & vbCr & "Rank : " & Cells(c.Row, 27).Value & vbCr & "Rank POS : " & Cells(c.Row, 28).Value.............................

View 4 Replies View Related

Looking For A Formula That Counts The Ones That Passed Or Failed The Audit?

Apr 25, 2013

I am working on a sheet that has over 150 tabs of information. It is a simple audit that allows for Yes, No or N/A to be selected for each audit category. I have an Outcome Summary tab that is pulling totals for all the audit information on each tab. I did a CountA statement to count any cells (from all worksheets) that had anything selected, so I have my count for the amount of files audited, but for the life of me I cannot come up with a formula that counts the ones that passed or failed the audit. Needs a formula that counts for Yes as 1, No as 0, N/A as 1 (these don't count against us) and doesn't return an error for a tab that wasn't selected.

View 3 Replies View Related

How To Make Audit Trail When First Change Is Made Right After Opening Excel File

Jul 30, 2012

Pls see below codes, the codes can record down changes made "from" and "to" and put on the "Log" sheet, however it is unable to capture the original values when I first open the file and make the changes.

Also, how can I put the value of "Now" in column B?

Code:
Dim PreviousValue
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Value PreviousValue Then

[Code].....

View 9 Replies View Related

Greyed Out Pages

Nov 25, 2008

I opened an Excel file, and the whole page is grey. I can't see the cell lines at all. How do I get it back to white with all my gridlines?

View 3 Replies View Related

Edit Links Greyed Out?

Sep 10, 2009

I've read a bit on the web about there being a bug with the 'edit links' feature. How/Can I get this function to work?

View 6 Replies View Related

Paste Special Is Always Greyed Out

Jul 7, 2006

Paste Special is no longer available in the Edit menu--it's grayed out. (I am using Excel 2003). I can't find any info on what disabled it or how to re-enable. It's probably something moronically obvious, but this moron needs a shove in the right direction.

View 6 Replies View Related

Some Sub-Menus Disabled - Greyed Out

Nov 6, 2006

I have noticed that the submenus for the following main menu items are disabled

Edit Insert Format Data

The submenus for the other main menu items are fine.

I have not run any macros that alter the menus.

I have tried Tools>Customise Reset Menu and Toolbar usage. I then exit the Excel session, but the problem still remains,

View 3 Replies View Related

Autosum In All Files Is Greyed Out

Dec 2, 2006

The Autosum in all my Excel files is greyed out. I am able to use the icon button to perform autosums but am unable to turn off "autosum" from the tool bar. I have turned the EnableAutosum to "true" in the Editor with no luck. What am I missing?

View 2 Replies View Related

Only Few Cells Normal - Rest Greyed Out

Mar 16, 2013

I sometimes come across spreadsheets that have only a few white, "normal" looking cells and the rest are grey with no borders.

Usually there is a thick blue line around the "normal" cells and I can make more cells look "normal" by dragging the blue border line.

What is this? And, how do I set it up in a spreadsheet if I need to?

View 2 Replies View Related

Redo / Undo Buttons Are Greyed Out

Aug 9, 2013

In some excel files the redo / undo buttons are grayed out

View 3 Replies View Related

Bold, Underline And Italic Greyed Out

May 8, 2009

My spreadsheet is locked and protected, and i have found out that the BOLD, underline and italic functions have been disabled, is there anything i could do via VBA to keep these functions active,...????

View 4 Replies View Related

Icons On Control Toolbox Greyed Out!

Aug 14, 2007

I've just finished writing some vb code that i need to assign to a button. Trouble is I select the control toolbox and put it design mode and all of the icons with the tool box are greyed out. pic attached below

pukks Auto Merged Post;Doh Doh and double doh!

Problem solved: I inadvertently had selected more than one worksheet tab and this was stopping me from placing a button on the worksheet.

View 2 Replies View Related

Excel 2007 :: Delete Sheet Greyed Out

Jan 13, 2009

I am using excel 2007 and when I right click on the worksheet tab, delete is greyed out. My workbook/sheet is not shared. I also had the problem owith row and columns. CommandBars("row").Reset sorted that out but I can't seem to sot out the tab issue.

View 6 Replies View Related

Hide Combobox But Move / Size Is Greyed Out

Nov 6, 2012

I've got Combo Boxes and at times I want to hide this. However, when I do, the combo boxes don't hide and are still visible. Here are my steps: Right Click on the combo box, chose Format Control, then under the properties tab, the choice to select "Move and size with cells" are greyed out.

View 4 Replies View Related

Excel 2010 :: Highlight Range And Right Click Greyed Out

Apr 4, 2014

I'm using Excel 2010 and when I highlight a range and right click 'name a range' is greyed out. I can bypass this by going to the formulas tab and defining a name from there.

Anything I can check to see why this is not an option for me?

View 3 Replies View Related

Macro Error In Workbook - Entire Ribbon & Icons Greyed Out

Mar 3, 2009

I ran a simple macro that I created in my workbook, got a run-time error, clicked debug, clicked reset to stop the macro running, and now all of the icons in my workbook are greyed out. I can select cells, change worksheets, enter information in cells etc....just I can't save the workbook, or select any of the icons on my ribbon / in the office menu. Would really like to avoid terminating the application as I made a number of changes that I didn't save (doh doh doh).

View 9 Replies View Related

Greyed-out Columns Based On Cell From Specific Column In Active Row Being Edited

Jul 7, 2014

I am making a spreadsheet in which I have been asked to have certain column greyed-out based on an answer that was given in a dropdown menu. Specifically, a dropdown menu in column D asks if the client was a Youth or an Adult. Depending on what the anwer is, other columns in the spreadsheet will be greyed-out; different ones for each answer. My problem is, I need this to occur for the active row being editted. For example: The first row that the user can input data into is row 4. If D4 is answered with "Adult" then certain other columns are greyed-out. However, if the next time the user updates the spreadsheet with information for a different client (now entering information in row 5) and they select "Youth" for column D5, then different columns get greyed-out. The columns that are greyed-out will depend upon the answer for the dropdown menu in column D for whatever row is actively being editted.

View 5 Replies View Related

Conditional Formatting IF Function To Identify Past Due Items In Red And Items Completed

Aug 13, 2014

I have a spreadsheet that lists a set of actions and the days they need to be completed.

The due dates are listed in column c and in column h I have a the user choosing "completed" from a drop down data validation.

I have a dashboard on a separate worksheet, showing if the item is complete and the due date.

Ideally I would like to display the dates on the dashboard in red if they are past due, and the box in column h was not marked complete.

I have been going through my books and trying to solve this, but I run into a different issues.

Even if for now If I can get the main worksheet to display the color conditional formatting that would work

View 2 Replies View Related

Count Items In Column That Match Multiple Data Items?

Mar 27, 2014

I need to count the total number of times 4 different values appear in a column. This formula works for one value:

=COUNTIFS(Source!$C:$C,$B5,Source!$J:$J,$L$3,Source!$L:$L,$H$1)

Where H1 contains the word Assigned. I need to also find and add to count for matches in I1,J1 and K1 which contain New, Pending and Work in Progress respectively.

View 6 Replies View Related

Select Multiple Items In List And Then Print Those Items?

Dec 26, 2013

I am wanting to create a list where I can select multiple items within that list and then print only those selected items. I have created something similar thru data validation, but I can't get it to print.

In addition, I would like to be able to subdivide the list into multiple categories, then select items from these multiple categories and print them.

View 3 Replies View Related

Excluding Selections: Added To The 20 Items And Not To The 3 Items

May 23, 2006

If i select 3 items from a list 20 items to be show on the cube this is fine and works however if i then add another item to the list i now have 21 items and for some reason it also adds itself to my 3 selected items to become 4 items. Is there anyway I can get it to be added to the 20 items and not to the 3 items..

View 4 Replies View Related

"Print Titles" Is Greyed

Aug 12, 2009

I have set an area to print which covers a few pages and I want them printed with the same row as a title. However, entering Print Preview - Page Setup - Sheet shows the section "Print Titles" greyed and I cannot select any row (nor columns).
What can be wrong with my set-up?

View 2 Replies View Related

Creating A Unique List Of Items In Column A That Have A Corresponding Non-zero Value In Column B, I.e. Excluding All Items Where Sumif ColumnB Would Sum To 0

Jul 17, 2009

I know how to use array formulae to create a unique list, i.e.{=INDEX($G$1:$G$760,SMALL(IF(ROW($G$1:$G$760)=MATCH($G$1:$G$760,$G$1:$G$760,0),ROW($G$1:$G$760)),ROW()))}

however this is giving all the unique items from column G and I only want the unique items that have a non-zero value in column H as well. This would be the sumif of all instances that would have to be zero. I've tried to crack it and I've tried to search for solutions but so far no joy.

View 9 Replies View Related

Cant See Drawing Toolbar

May 22, 2007

I've recently got a new computer and this problem is driving me nuts.
When I click view!toolbars!drawing, nothing happens. No drawing toolbar appears at the bottom of the screen where it used to be. There's a small "drawing toolbar" icon on the main toolbar, but whether this is depressed or not makes no difference either.

I understand this may be changed in the 2007 version, but I’m using Excel 2000

View 10 Replies View Related

Customize Toolbar...

Oct 12, 2009

There is something that is bothering me in excel. Every time I open a workbook, on my toolbar appears the "Reviewing" one. I tried to unchecked it from the customize toolbar option but still appears on opening a new workbook ((.

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved