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


ADVERTISEMENT

Macro Won't Execute Code To Put Focus On "print To X Pages Wide By X Pages Tall"

Feb 20, 2009

I'm trying to execute a macro and it won't put the focus (radio button) to select x pages wide by x pages tall in the Page Setup/Page/Scaling Area. I looked at the macro and can't find a setting in the code but yet the focus won't change. What can I do about this? In other words the radio button stays selected as "adjust to "" % of normal size. Here's the code...

View 2 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

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

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

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 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

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

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

"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

What Pages Are Not Seen

Oct 30, 2008

I have a website with lots of pages and I have a tool where I can see how many visits these pages get. What I want is to find out which pages didn't get any visits.

So I have in one column all the pages URL's on my site
In the other column I have all the pages URL's that have been visited, and in the column right next to it I have the amount of visits that page has received.

For example, this is what it looks like today:
column A:
row 1: /site/hello.htm
row 2: /site/how.htm
row 3: /site/are.htm
row 4: /site/you.htm

column B:
row 1: /site/are.htm
row 2: /site/hello.htm

column C:
row 1: 10
row 2: 20

Ideally the URL's that have been visited should show up on the same row as the URL in column A, and then for the ones that have not been viewed it will just be blank in column B and C.

so in the above case it would look something like this:
column A:
row 1: /site/hello.htm
row 2: /site/how.htm
row 3: /site/are.htm
row 4: /site/you.htm

column B:
row 1: /site/hello.htm
row 2: [blank]
row 3: /site/are.htm
row 4: [blank]

column C:
row 1: 20
row 2: [blank]
row 3: 10
row 4: [blank]

View 13 Replies View Related

PDF Every 2 Pages

Aug 20, 2014

I am trying to create a PDF of every 2 Worksheets. I currently have this code that creates my PDFs for each individual sheet but I need it to group 2 together. Ex: Sheets 1 & 2 a separate PDF, Sheets 3 & 4 a separate PDF and so on.

[Code] ......

View 5 Replies View Related

Updating Pages

Nov 7, 2007

Is there a way to insert a cell/row, and add data to one page/tab, and have it automatically insert a cell/row and add the data on another page/tab?

Excel 2003 is the version I am using.

View 14 Replies View Related

How To Count Pages

Dec 19, 2013

I'm trying to find an easy way(or any way) that I can have excel automatically insert a page number into my document. I'm looking at 60+ pages on separate tabs that I will be adjusting and modifying for a few weeks yet and I don't feel like continually fixing page numbers.

View 3 Replies View Related

Switch Tab Pages???

Mar 27, 2009

I have a user form that has several tab pages on it when the form opens it checks to see if the user has entered there default info if it is empty it needs to go to the default tab so the user can enter there info. How do I do this using vba in excel 2000 I have not been able to find any code that will do this if I use the set focus option for a text box on the tab page it comes up with an error saying the item is not visible! The user forme is names = UserDataInputForm. The tab pages I have are

1st = InputDailyTimesPage
2nd = OverTimePage
3rd = DataPage
4th = DefultDataPage
the form opens using the 1st tab page by default
in the user forms inisilisation code I have this check

View 2 Replies View Related

VBA To Add Pages To Existing PDF?

Dec 14, 2012

I have created a spreadsheet which serves as a reporting portal - if you select a product from a drop down, the spreadsheet automatically updates with data regarding that specific product. I would like to give my worksheet the ability to select a new item from the dropdown (that part i can do) and then print each of these product reports (1 page each) and aggregate them into one large pdf.

View 2 Replies View Related

Formulas Between Pages

Jun 20, 2007

I have a formula that checks the previous page(Tab) for a figure so the formula goes =SUM(F37-'05-27-2007 thru 06-02-2007'!F37). Is there a way to instead of asking for the page '05-27-2007 thru 06-02-2007' to have it generically ask for the previous page?

View 9 Replies View Related

Table Headers Not On All Pages?

Sep 15, 2014

I have a long growing statistical report(18 pages + more), and 14 of the pages will use report table headers. I went into the page set up and selected the row to repeat on each page. I do not want the table headers on any pages after 14. The rest of the report is formatted differently and does not use the row headers. but all of the information is related. Is there a way to only show the row headers up to page 14? I can't use headers and footers, of course. The report will be set in one place and the user will print it out once a week. It seems as if this cannot be done but I this is my last resort.

View 4 Replies View Related

Reflecting Particular Cells On All Pages

Jul 14, 2014

I am trying to print this document and it has several pages.

My problem now is I don't want to copy the header (all content of Cell 1 to 4) into all the pages.

Is there a way I can leave it the way it is and it will reflect on all the printouts?

I mean on all the pages that will be printed?

View 4 Replies View Related

Web Queries For Multiple Pages?

Dec 10, 2008

My question is about webqueries... specifically how to set up a query that will automatically fetch data on different pages (same data, but includes page 2, page 3, page 4, etc )

I've just figured out how to import a "new web query," but it seems like I won't be able to import 63 pages of it unless I do all of them by hand.

View 7 Replies View Related

Create New Pages From A Template?

Mar 18, 2013

I have a workbook that has a total of 128 pages. The problem is that a lot of those pages won't be used. Basically I have a sheet that needs to be filled out for each day up to around 30 days, sometimes more, most times less.

Currently I have created all the sheets that I will typically need (31 daily's, 31 daily printable reports).

Data is entered into the daily (and other spots) and then with the use of formulas transferred to the report sheet which is hidden and then printable with the use of macros.

I also need to withdraw some of this information (CSV File) to be able to populate a database.

Is it possible to have my "daily" page as a template and then create the subsequent pages as I need them? (this would have to be done with a bunch of other report pages as well). For ease of use I would need all the formulas etc that I currently have to be able to be "created" as well. As an example, there is a running total of costs associated with the "daily" pages that would need to be carried forward.

View 8 Replies View Related







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