Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
  Advanced Search
  HOME    TRACKER    Excel


Advertisements:










Hide Freeze Pane Guideline


When using the freeze panes excel places a guidline that appears at the top of the scrollbar but this can spoil the presentation.


View Complete Thread with Replies

Sponsored Links:

Related Forum Messages:
Freezing A Pane On The Top AND The Bottom
I would like to have the column titles stay so I have frozen row 1. But I would also like to freeze row 200 so I can keep up with the running totals at the bottom of the form as I fill in information. Is it possible to freeze a pain at the top and the bottom?

View Replies!   View Related
Unable To Get The Task Pane To Display On Startup
I am working in Excel 2003 and have recently lost the Task Pane when I start Excel. The box in Tools Options to display the task pane is checked. I have modified the registry to include a DoNotDismissFileNewTaskPane value and have even added the following code to the Personal.xls file:

Private Sub Workbook_Open()

On Error Resume Next
Application.CommandBars("Task Pane").Visible = True

End Sub

If I remove the On Error Resume Next line I get the following error:

Runtime error '-2147467259 (80004005)' Method 'Visible' of object 'commandBar' failed

I did add the Analysis Toolpak last week but am not sure that this had anything to do with it.

I can go into the View menu and show the Task Pane and do have the CTRL+F1 option to display it.

View Replies!   View Related
Disable Alt-click Opening Research Pane
Simple question: How can I disable the Research Task Pane from launching when I Alt-click in Excel 2003?

Further Explanation:
I have an Excel Add-in (commercial, not my own) that will retrieve data from an outside server when the user presses Alt-Double Click. Work's great. I've now upgraded to Excel 2003, so anytime I Alt-Double Click, Excel opens up the "Research Task Pane" (Pain?). To make matters worse, I'm behind a corporate firewall, so I get an authentication challange in order to connect to the internet when this opens. Don't want it, don't need it, want to get rid of it. Any solution is fine - Option setting, VBA, Registry setting

View Replies!   View Related
Trying To Freeze A Sheet
I have multiple sheets as part of my excel calculations which refer to the first sheet in the group. Each one calculates different values for me based on the numbers I put into the sheet.

So to put in these numbers, I insert new rows to the start of the sheet which is what I always want it to calculate. Some of the calculations are comparative to other points from my original page. So I might ask it to go back and compare to 3 months ago or 6 months ago.

Long story short, when I insert those new rows, the formula on the other pages shift down to stay on the previous days data. How can I lock it in so it stays focused on just the cell I tell it to reguardless of how I move those cells around. So when i hit insert, I still want it focused on that sheets A1 and NOT A2.

I attempted to look up the help section but since I am having a hard time putting this into words, help was not much "help".

View Replies!   View Related
Freeze Panes
Just wondering if I can lock a worksheet to display the content within the window only. Eg 22 Rows by 6 Columns? Therefore stopping people tampering or moving objects?

View Replies!   View Related
Freeze Top 2 Panes
I tried highlighting the top 2 rows and clicking 'freeze panes' but it didn't seem to freeze correctly

View Replies!   View Related
Freeze Panes Using VBA
I'm trying to get one of my macros to freeze panes in several worksheets. For some reason though, sometimes it freezes the panes in the wrong place. What could be causing this? My code basically looks like this:

View Replies!   View Related
Vba Printpreview Freeze
when ever it runs it brings up the print preview of the correct sheet (looks just like i wanted) but the vba object stays infront of the print preview window and locks up i cannot close it and cannot access the print preview window because it is blocked by the vba object even though i can see the print preview in the backbround.
i have tried asding "unload me" after the "activesheet.printpreview" line but does not make any differnce i end up having to close excel via task manager and reopen it.

Private Sub cmdPrtPreview_Click()
On Error Resume Next
Sheets("invoice").Select
ActiveSheet.PrintPreview
End Sub

View Replies!   View Related
Freeze Value In Cell If Criteria Is Met
Just wondering if its possible to achieve the following please:

If Y5=U5 then place text "High" in cell Y4

and

If Y6=U5 then place text "Low" in cell Y4

BUT

how can i make it so that once the above criteria is met, and the relevant text is placed in cell Y4, how can i make it so that it Keeps that Value in Y4 now (even if Y5, U5 or Y6 change afterwards)?

View Replies!   View Related
Web Query Causes Workbook To Freeze
I've had this workbook freeze during a perpetual dynamic web query for quite some time now and have mentioned in a few previous posts while trying to elimnate probable causes.
Nothing suggests anymore it's codes or structre of the codes in Excel or even physical memory issues.

Symptoms as best as I can describe.

It only seems to happen when observing some extra internet activity due to the icons flashing on the task bar, in a split second.

For example, perhaps; auto-update checks, browser pop ups when logged in to a secure web site, or I even suspect maybe some sort of Ping, yet it's part of the overall standard operation of Wndows OS Ping.

From my intense observations it's always when the 2 TCP icons on the task bar flash an extra "beat".

Hope this makes sense in trying to describe a cause or symptom.

The nature of this glitch happens on all computers in both Office 2000 and now 2003 versions of Excel.

Fresh install of the entire OS has been done with standard Installation and a fresh re-insatll of Office,with or without security softwares etc.

It's always exactly the same, it will freeze at the precise moment the flashing icons is not the regualr sync. during the perpetual web query process.

It will freeze all worksheets, meaning I have to Close and Re-open the Workbook and it's ok till it happens again.

Where to now with this glitch, or would it have something to do with certain port settings?

View Replies!   View Related
Auto Time Freeze
I have a long sample list, (names and telephone no.), once a name and number
are used an outcome code is entered in the end cell like so ...

View Replies!   View Related
Freeze Panes VBA Without Select
Anyone know if it is possible, in VBA, to freeze the panes of a worksheet at a specific cell without selecting that worksheet or the cell.

View Replies!   View Related
Freeze Rows AND Columns
Is there a way to freeze both rows and columns? I want to freeze the first five rows 1-5 and columns A-C and have the ability to scroll while having thee rows/columns static?

View Replies!   View Related
Nbtext Fx From The Morefunc Add-in Freeze
does anybody know why i can't seem to use the nbtext fx from the morefunc add-in? it will freeze my computer up everytime i try and use it.

View Replies!   View Related
Freeze The First Column On My Spreadsheet
I am wanting to freeze the first column on my spreadsheet (easy) but also the top few rows. Every time I try (am using 2007) it seems to make a strange selection where it splits the screen exactly into 4 equal parts rather than just the first column and top 4 rows.

View Replies!   View Related
Freeze Panes In 2 Places
I'm looking for a solution to freeze panes twice. That is I want to freeze row 1-15 and row 200-203. And then the rows 16-199 to be movable. In the first 15 rows I have column info so I need that visable all the time and in row 200-203 I have " Sum" of the lines 16-199 so that's why I want that to also be visible at all time. The ordinary freeze pane in excel just freezes at one certain horizontol point and I need 2. Can it be done with VBA maybe? Is it possible to insert an up/down arrow (the one you have at the right side of the screen, don't now what it's called) for the lines 16-199?

View Replies!   View Related
Freeze Time Or Not Changed In Cell
I know that =now() will give me the time, and keep updating itself, but is there a formula I can use that will give me the time the cell was written into and maintain that time .. example, if I entered something into the cell at 3:45:21pm I want that time recorded in that cell and not change as they day moves on

View Replies!   View Related
Freeze Left-hand And Right-columns
Does anyone now if it's possible to freeze left and right hand columns simultaneously eg. cell C3 above and left AND cell DB3 above and right?

The columns on between would then scroll left or right, until the static column was reached?

View Replies!   View Related
Disable Freeze Panes And Sort?
Is there a way I can disable Window > Freeze Panes and Data > Sort from a shared workbook?

View Replies!   View Related
Freeze Panes Code Not Working.
Freeze Panes Code not working.
Below is the code im not sure whats up with it?

View Replies!   View Related
Freeze Panes When Scroll The Rows
If is possible to create any info about freezing panes. I mean, when is pan freezed, and rows are scrolled in lower part of table (upper data are not vissible) if is possible display/show any text about this (e.g. "The first line of table are not visible")...but only if is not the upper part of data visible..not always.

View Replies!   View Related
Freeze Panes Toggle Button
I have a sheet in which I am using freeze panes to keep the header section always visible. I would like to be able to add a toggle button with a macro to the sheet to allow the user to turn the existing freeze panes on/off at will, without the need to navigate the menu bar itself. So far I have not been able to find any info on if/how this may be possible. If anyone has any experience controlling freeze panes via macros, etc.

View Replies!   View Related
Tools & Format Options Cause Freeze
On one of my computers, Excel is freezing up just about any time I select something from the Tools or Format Menus (same goes if I use keyboard shortcuts to call any of those things). I have to kill it with the task manager. It is not a specific workbook, I've tried several, including new blank workbooks.

It's not all menus, as File options seem to work. I also am able to Autosize columns by double clicking, but basically any other formatting things (i.e. CTRL + 1) do not work. I also tried to show the Cell Format dialog via VBA, (note: I am able to get to VBA editor, etc...), and it locked it up then too.

Finally, I tried "Detect & Repair" from the Office disk, but that didn't do anything. Next, if necessary, I'll do a full re-install unless anybody else has heard of this and knows what the problem is.

View Replies!   View Related
Invert The Effect Of Freeze Panes
I would like to freeze the bottom part of my spreadsheet, such that the user can scroll through the upper part but still be able to see the bottom part. The freeze command freezes what is above the line, I want to freeze what is below the line.

View Replies!   View Related
Freeze Column And Row Height And Width
I need to freeze the column and row height and width for a specific area in spreadsheet, so that it shouldnt be altered in future from any one using this sheet.

View Replies!   View Related
Freeze Horizontally And Vertically At The Same Time
How do you freeze horizontally and vertically at the same time?

View Replies!   View Related
Why Are Page Freeze Codes Destined To Fail?
When I'm manually formatting a spreadsheet I'll almost always freeze the header row for ease of navigation and to keep the headers in view. However when I attempt to do this in my code it seems no matter how careful I am it inevitably freezes the page in some peculiar location which bears no relation to the instructions I give it. Even knowing this annoying fact I'll take the extra step of turning off freeze first to clear any existing situation before setting my prefered freeze. ... and it still blows up in my face

Sheets("RTN").Select
ActiveWindow.FreezePanes = False
Range("F4").Select
ActiveWindow.FreezePanes = True
Is there any fool proof way to freeze rows?

View Replies!   View Related
Workbook Causing Intermittent Freeze & Not Responding
I recently added some command buttons to 6 excel files each with about 20 sheets. most of the sheets got 6 new buttons. After I added the buttons I would get memory errors when I treied to open other files. So I upgraded to Office 2003 and Excel 2003 because I read that it had increased memory available. It did not seem to help much, and now on average about evry say 10 minutes Excel hangs for about 1o seconds, sometimes saying "Not Responding" up the top. Then it starts working again. MY PC has Server 2003 and 1GHz and 512MB of Ram. Here is some info:

=INFO("memavail")1048576
=INFO("memused")50769256
=INFO("totmem") 51817832
=INFO("numfile") 173
=INFO("osversion")Windows (32-bit) NT 5.02
=INFO("release") 11.0

I do not think the PC memory or chip is being stressed it seems to be Excel's memory?

View Replies!   View Related
Freeze Panes Prevent Full Comment View
I have an issue, and I need some help. I am using MS excel 2002.

I have frozen the line with the column headings. In some of the column headings there are comments. Because the panes are frozen when the user scrolls to a certain point the comments cant be seen. Is there any way to fix this? or get around this.

View Replies!   View Related
Return To Original Cell After Freeze Panes Macro
I have a workbook where I have columns requiring entry from A to AD. I have set conditional formatting in column A to show a colour if there is an entry in column AD. I would like to use a macro to always freeze panes in column D (to show the data in the first 3 columns) and the macro would then show column AD in the other frozen pane/split.

As there will always be an entry in column A but not always in column AD I want to be able to select any highlighted row in column A , run the macro and the cursor will be showing in column AD on the same row ( relative reference?) thus showing the entry in AD next to the other info in columns A, B and C.

At the moment I have a macro that unfreezes my header row and is set to always choose the "next empty cell" but I don't know the code to change it to get what I want. Currently if I select any entry in column A e.g. row 100 and run the macro I find the cursor showing in AD2! Of course I would like to run another macro to return back to A on the same row too.....

View Replies!   View Related
Freeze Columns/Rows In Worksheet Index Code
I used the code in the link for "Create Worksheet Index" you referenced and it works great. Is there a way to have the Index and the "back to Index" links appear in separate stationary windows on the left side of the spreadsheets?

View Replies!   View Related
Query Hide State Of Column Ranger And Hide If False
I want to create a macro that checks whether a specified range of columns is hidden, and

a) hide them if they are not hidden, or
b) unhide them if they are hidden,

i.e. toggle the Hide state.

What method can I use to query the hidden state of a selected range of columns and return a boolean value?

View Replies!   View Related
Hide Columns & Hide X-axis Labels
I am filtering the data displayed in a chart by hiding columns. I would also like to filter the X-Axis labels by hiding columns. If I do this manually I have no problems but when I run the following macro the chart gives a reference error for the X-axis labels.

Sub ShowA2()
Application. ScreenUpdating = False
num = Sheets.Count
Sheets("X-Axis").Activate
Range(Columns(1), Columns(256)).Select
Selection.EntireColumn.Hidden = False
For a = 1 To 5
Sheets(num - a).Activate
If ActiveSheet.Name = "A2 Data" Then
Columns("A:Q").Select
Range("A10").Activate
Selection.EntireColumn.Hidden = False
Sheets("X-Axis").Activate
Columns("A:E").Select......................

View Replies!   View Related
Row Hide
If I want to hide row a15 when cell value in k5=1 and also if cell value in k5=2 then hide row A16.

View Replies!   View Related
Hide A Tab
is there a macro or bit of VBA code that can hide a worksheet tab when criteria in an if function is true???


View Replies!   View Related
Hide Value Other Than Zero
How can I hide the value in column H when there is no value in column E, but still be able to fill down the formula in column H as many rows as I want?

In other words, I don't want to see the totals in column H in rows where the items haven't been sold yet (col. E) or in rows where there is no other data at all. Items are not always sold in the order in which they were purchased but I still need the formula in column H to be intact.


View Replies!   View Related
Hide Zero In PT
how can i hide zero from Pt. i am using xl2003

View Replies!   View Related
Hide #N/A
I have a big formula with 6 IF functions and i whant to display 0 when formula returns #N/A.

I can't use IF(ISERROR()) because there are to many IF's functions

View Replies!   View Related
Hide Formulas That = 0
Is there a way that you can keep formulas from showing 0's. I want the
totals to only show when the value is < 0

View Replies!   View Related
Hide On Open
Ok what i would like is when i open a certain excel file it hides the command bars the sheet prity much all of excel. though Must still be able to show the userform.

View Replies!   View Related
How To Hide #VALUE! In Cells?
There are empty cells in a column.

Where the cells are empty, they are reading #VALUE! because I have copied down a formula in all other cells above and below etc.

Is there any quick way of making the #VALUE! disappear or by hiding?

(Other than the copied formulas in the column, there are also conditional formatting so when the numbers drop below zero value, it turns the numbers red).

It's a long sheet and I want to avoid deleting each #VALUE! by hand!

View Replies!   View Related
Hide A Worksheet
I want to know how do I hide my "Raw Data" worksheets? I have about 10 worksheets in a workbook and just need to hide the first one - where all the raw data is store...


View Replies!   View Related
Hide Vs Unload
I use several different userForms at different times in my macro. I am having an issue where soemtimes Excel will be stuck (not frozen) after I close a form. Its almost like the form is being hidden but Excel thinks that it is still visible, so execution halts.

I've tried leaving the form with both me.hide and unload me. My code is pretty lengthy, so I don't think submitting it is appropriate. I believe my problem is my own lack of knowledge on hide vs unload.

Can anyone help me out here?

View Replies!   View Related
Hide Row On Click
Looking for a way to hide a given area of either rows or columns using a hide/unhide button command.

View Replies!   View Related
Hide Errors #Value
I am creating a spreadsheet which shows the date of when the training was cpmpleted. I have added an expiry column which gives the date 3 years from start date no problems. The trouble i am having is that the column will return an #VALUE when no training date is entered. ie: the person has had no training so no date can be entered.


View Replies!   View Related
Hide Worksheets ..
I have attached a spreadsheet, which has a master data sheet and 2 other worksheets (Sheet 1 and Sheet2) that have linked Choose Functions from the main data worksheet.

I would like to send copies of Sheet 1 and Sheet 2 to seperate people, however would not like them to be able to view each others worksheets or the Master Data sheet, as it is sensitive data.

Does anyone know how I could create a macro, that enables me to click a button which would protect & hide two of the worksheets including the name of the worksheet (e.g. protect & hide worksheet "Data" and "Sheet 2"). This way I could send the entire spreadsheet to someone while hiding the sensitive information.

View Replies!   View Related
Hide Criteria With VBA
I'm attempting to update a previously created workbook with VBA.

The last four rows (80:84) need to be hidden if a particular cell's value is equal or greater to 12%. Even if this cell has been merged (P10:Q11) and its contents are a formula (D10-A9)/A9.. would there be a macro to solve this?


View Replies!   View Related
Hide Tables Using VBA
I am after some code that will hide tables based on whether they contain certain values.

If we take the following example: ....

View Replies!   View Related
Delete/Hide Every Nth Row ...
How to skip every second row (delete or hide) of an array of data (two columns) in a worksheet. I have too much data and want to delete every other row at a regular interval (increase step interval from 1 to two or even three). Tried to do this with VLOOKUP and Filter (custom)

View Replies!   View Related
Hide Various Columns
I have a very large spreadsheet that I work in and then print from. When I print, I need to hide about 20 columns which I do manually. I am curious if there is a way I can do this easier. If I could somehow filter columns, or set mutliple columns to a name for a dopr dowm box, or possibly a macro.

View Replies!   View Related
Copyright 2005-08 www.BigResource.com, All rights reserved