Scroll Area Set But Won't Stay Put?

Oct 29, 2007

I set the scroll area on a worksheet and saved the file. The next time I open the worksheet the scroll area is no longer set.

View 7 Replies


ADVERTISEMENT

Search Selection With Scroll Area Set

Sep 14, 2013

I have a spreadsheet form with a bunch of cells receiving and writing data via vba. On the form is a search box. The data is on the same sheet as the form to prevent flickering by activating another sheet. The problem is that I cannot select the search area and set the scrollarea or the "Find" quits after the first find:

if I have 2 jacks then it will find the first and not the second.

If I don't set the scrollarea of course it goes to the selected cell and moves the form out of the picture.

If I select a cell in the form area after the search, the "Find" is reset to the beginning and locates the same cell again.

Here is the code:

Code:

On Error GoTo DataNotFound
Cells.find(What:=txtFindText, After:=ActiveCell, LookIn:=xlValues, LookAt:= _
xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:=False _ , SearchFormat:=False).Activate

[Code]....

View 9 Replies View Related

Locking A Large Scroll Area

Feb 28, 2007

Can a scroll area be locked at any size using VBA code? I am able to lock area A1:J20 in the Private Module of a worksheet but nothing larger.

View 6 Replies View Related

Lock & Limit Scroll Area

Jun 16, 2008

I want users to be able to scroll top-down or sideways up to a certain point only.
What is the VBA code to accomplish this? Let's say for example I want to limit scrolling from A to L rows 1 to 50 only.

View 2 Replies View Related

Scroll Area Not Saving When Workbook Closed

Nov 15, 2006

Ive tried disabling scroll on sheet 1 of my workbook by entering the cell range into the properties window in VBA. However when I save the sheet and reopen it, it seems to reset and are able to scroll again.

I tried using the following:

Private Sub Worksheet_Activate()
Worksheets(1).ScrollArea = "A1:Q51"

End Sub

and a few variations of the above but this dosnt seem to be working. The only other code I have in the workbook is under "thisworkboko" which is this:

Private Sub Workbook_Open()
Application.DisplayFullScreen = True

End Sub

View 5 Replies View Related

Scroll Area And Hiding Unused Portions For Entire Workbook

Jun 27, 2012

I use all of column A, B, and C, but i only use D1 to H44 other than that. Is it possible to hide everything to the right of Column I and below D44:H44, but leave the scroll area for columns A B C able to scroll to the bottom?

View 6 Replies View Related

Limit Scroll Area - Code Activates Only On Mouse Or Keyboard Input

Apr 21, 2007

I have a worksheet that serves as a navigation page for the workbook and use the following code to restrict from scrolling off the viewable content. The problem is that the code doesn't kick in until either a click if the mouse or keyboard input. This initially leaves the worksheet open for scrolling until input is received.

How do I make this code activate when the wb is loaded? Code in the Thisworkbook module already makes the menu the visible sheet, and code limiting the scroll area is in the sheet module.

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
With ActiveSheet
.ScrollArea = "A1:L11"
End With
Range("A1").Activate
End Sub

I've also tried using "Range("A1").Select", but it doesn't work either. How can I get this to work correctly?

View 2 Replies View Related

Restricted Scroll Areas Won't Scroll

Nov 26, 2007

I am using the toolbox/ properties method to restrict the scroll area in the sheets of my workbook. However, for some sheets when i keep the right hand arrow pressed, the screen will not scroll to the last column. (i.e. the screen display will not move with the selected cell box)

View 2 Replies View Related

Control Scroll Bars: Remove The Scroll Bars From Just One Worksheet But When Unticked

Jan 13, 2007

In the menu via TOOLS-->OPTIONS-->VIEW I am trying to remove the scroll bars from just one worksheet but when unticked, this option affects all of the worksheets in my workbook. Is there a way to just nail this selection down to one sheet via properties?

View 2 Replies View Related

Print 2 Selected Area (highlighted Area)?

Apr 11, 2013

How can I print 2 selected area (highlighted area). I know there is a trick to do that. Right now I can only select (highlight) one area to print, but would like to know how to print 2 or more areas at same time

View 7 Replies View Related

Programmable Print Area: Macro To Set The Print Area According To The Amount Of Data In A Particular Range Of Cells

Feb 25, 2009

Using Excel 2003 I am trying to write a macro to set the print area according to the amount of data in a particular range of cells. I find I can include this instruction

View 2 Replies View Related

Graph The Following Data In An Area Chart With Line Charts Superimposed On The Area Chart

Nov 1, 2006

I am trying to graph the following data in an area chart with line charts superimposed on the area chart. I have a lot of data (and a lot going on) so I'm trying to figure out the best way to show this in excel from a functional standpoing (i can't get this to work in excel!!) to also an asthetic standpoint (dont want it to look terrible or illegible). This is what I'm trying to chart:

1) Weather data (temperature) by region:
So one region, would be: Northwest
I would like the "area" (so a shaded region) to be the min/max of the temperature data for each month.

2) I would like to show the temperature for each year as a line graph on the chart - so you can see if a year falls in or out of the shaded region.

3) I would like to show a company's sales increases across the same months per year as separate line charts. I may choose to just show the biggest outlier year in the end... or to show 2006 (the latest data).

What I am trying to convery with the chart is that the company's sales is or is not tied to weather deviations. I have attached an excel file with the data. I haven't been able to use the area chart or get a two axis chart to work or get it to look even remotely professional.

View 3 Replies View Related

Stay The Same Or Substract

Oct 11, 2008

In Cell O4 I have a number 35 that number never changes.

Now in Cell C40 I have another number that is a formula. the formula gives me a total of how many points are left.

In C42 I want the total to either been 35 or subtract the negative number from 35, the points can never go over 35.

Any number that is a positive or 0 will equal 35, if a negative number subtract from 35.

View 9 Replies View Related

How To Set Fixed Print Area In Excel So Cells Within Print Area Can Still Be Modified

Feb 12, 2013

I have a workbook with multiple sheets that I need to print.

Is there a way to create a fixed print area within which you can mess around with formatting without extending or shrinking the print area?

I have tried adjusting the margins settings so that they are all the same, but this does nothing to keep a fixed print area.

View 1 Replies View Related

Columns Won't Stay Formatted

Jan 9, 2009

I have Excel 2008 for Mac (vers 12.0). On a basic spreadsheet, the first column is for date which I have formatted so I can type in 15/8/9 and it appears as 15-Aug-09.

However, each time I open Excel after having Quit it, I have to reformat the cells in this column again as they revert to converting my date input with something like 39,123.

My other columns are formatted to currency and are always okay.

View 10 Replies View Related

Userform - Tab Selection Won't Stay

Jul 25, 2014

1. I have a userform I created that has a text box that pulls it's data from one of the spreadsheets tab. The userform also has 5 buttons I shall call Tab1, Tab2, Tab3, Done, Cancel.
2. The first thing a user will do is make a selection from the text box.
3. The User will then select one of the "Tab" buttons.

Below is my code. What happens is that no matter what button I click (Tab1, Tab2, Tab3) it ends up on Tab3 because it is the last transfersheet line of the done_click() sub routine. How do I get it to stay on the Tab I select?

+++++
Private Sub cancel_Click()
Unload UserForm
End Sub
+++++

Private Sub done_Click()
Dim transferworksheet As Worksheet
Set transferworksheet = Worksheets("Tab1")
transferworksheet.Cells(5, 7).Value = Me.ListBox1.Value

[Code] ..........

View 4 Replies View Related

Time To Stay As Text

May 30, 2008

I have a spreadsheet that tracks employee stats. Most of these stats are amounts of TIME. These times are being pasted from another source and the problem I'm having is that as soon as excel sees "1:02:03" it puts it in TIME format. The problem I have with that is later on I need it in text format because a lot of the other times are in text already. (the program the info is coming from will use ":59:59" and not have a 0, so I have compensated for that later) So how can I paste 1:01:01 and not have it saved as TIME? I cant CONVERT it to text, I need it to be text from the start.

View 9 Replies View Related

Formula To Hide Or To Stay As It Is Until Value Is Entered

May 16, 2014

In Spreadsheet A Cell H8 is entered as Item Description.

In Spreadsheet B Cell H8 is also entered as Item Description, but if the Item Description in Spreadsheet A has been changed, I need Spreadsheet B to reflect that change, if not it should stay as Item Description.

View 5 Replies View Related

Make Numbers In Formula Stay The Same

Oct 2, 2008

I have a formula:
=INDEX('Part Info'!E1:E300,MATCH(1,('Part Info'!A1:A300=A1)*('Part Info'!B1:B300=B1),0))

I want the E1:E300 to stay E1:E300 when I drag it down but I want the A1 for example to change to A2, A3, A4 and etc.

View 2 Replies View Related

Vlookup To Stay Blank If Nothing Selected

Nov 23, 2008

i have this formula which works well...

View 8 Replies View Related

Lock Column Header So That It Will Always Stay At Top?

Jan 28, 2013

How do I lock a column header so that it will always stay at the top as I scroll down the page?

View 4 Replies View Related

Marco To Stay In Selected Cell

Apr 1, 2014

I am running the below macro which work fine ! However after running the macro, I do not stay in the cell I was!! How to stay in the selected cell?

HTML Code: 

Sub INSERT()
ActiveSheet.Unprotect Password:="P@ssw0r!"
ActiveCell.EntireRow.INSERT

Range("FORMULA1,FORMULA2,FORMULA3,FORMULA4").Select
Selection.Locked = True
Selection.FormulaHidden = False

ActiveSheet.Protect Password:="P@ssw0r!", AllowFormattingCells:=True
End Sub

View 1 Replies View Related

Using Median Length Of Stay With A Look Up Function

Oct 7, 2008

I have two columns of data

1st - Multiple physician names (may be duplicate as data set is Emergency Room encounters)

2nd - Denotes the length of stay in minutes for each patient encounter

I want to develop a formula to calculate the median length of stay (off 2nd col) for every physician a select in a drop down.

View 4 Replies View Related

R1C1 Reference Style Won't Stay Gone

Dec 12, 2011

Every time I copy and paste cells in a specific workbook it changes the reference style to R1C1. Setting it back in the options, saving the document, closing Excel then reopening brings it back as A1 referencing but copy and paste will again return it to R1C1.

I've checked for VB code and there's nothing there either.

View 1 Replies View Related

Excel 2003 :: Get Some Information To Stay Still?

Jan 29, 2012

While using Excel 2003, I am aware of "freeze plane" and "split worksheet". The freeze plane comes in handy if I want to the first few rows to remain stationary and displayed while I can scroll down to the rows below. Similarly, the split worksheet comes in useful if I want to have the first few columns remain in place while I can maneuver to the right to see the other columns.

*** THE QUESTION IS: how can I get cells A1 to F20 to remain displayed and unmoved even if I choose to move the active cell around anywhere between G1 to K9999

View 9 Replies View Related

NAME Doesn't Stay Attached To The Cell

Mar 19, 2008

I have a cell (H27) which has a (sum) total in and have attached a NAME FRED.
This is fine as long as the client doesn't add a row above it.
If they do when I re-open the sheet the NAME doesn't stay attached to the cell (now H28)

Is there a way to keep the NAME attached to the cell regardless where it is?


Private Sub Workbook_SheetActivate(ByVal Sh As Object)
Range("$H$27").Name = "Fred"
End Sub

View 9 Replies View Related

Highlight Every Other Row & Stay Highlighted After Sort.

Apr 22, 2006

I have an excel spreadsheet that shows every other row in a pale blue. When I do data sorts, the rows loose their order. Is there a way to keep the row color in every other row and still keep it that way after the data is sorted?

View 2 Replies View Related

How To Make Text Boxes To Stay In Place

Nov 13, 2013

I have text boxes for additional information. Is it possible to make text boxes to stay in place so that if I or someone else deletes a column the text boxes would not shrink and move to the left?

View 2 Replies View Related

Code To Move To A Cell (stay In Top Corner)

May 11, 2009

I want code to move the cursor to A788

But keep A788 in the top left corner on screen.

Is there easy code to help me accomplish this?

Also, Is there code that will take you to the first cell it finds closest to today's date.

Dates are in Column B.g

View 9 Replies View Related

Cursor To Stay On The Cell After Pressing Enter

Jun 23, 2007

Imagine you have only one column - column A. In column A you have 500,000 + rows with text like the following:

!magnus
snooze'
sleepy/
act noun
act verb
Today&tomorrow
*bialgebras
/dev/ null
dev
ull
1970;
Dwight Schrute

and your goal is to figure out a way to simultaneously transform the above rows into:

snooze
sleepy
act
act
Todaytomorrow
bialgebras
devnull
devnull
1970
DwightSchrute

I know I can use Filter and filter out characters like &'!/; but that takes too long because I have a lot of lists to go through with thousands of entries. There must be a macro that will close spaces between words when only one space exists, but eliminate every word if 2 or more spaces exist between words - as well as eliminate unwanted characters like the ones I described above. I know I could use substitute and eliminate the spaces between words =substitute(a1," ","") but then I'd have to filter each and every instance of unwanted character.

View 6 Replies View Related







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