I have adapted Andy Pope's scrolling chart and have done some searching here on how to adapt this chart to plot at least two lines. For example, have sales data for the months of 2005 on one line and sales data for the months of 2006 on the other line so that corresponding months move together. I read a previous thread suggesting to change the source data to include the new data however I get a reference error message. I have attached the example that I am currently working on
When i add a month coloumn,Sparklines and Average coloumn should get updated automaticaly.Now this is not happening even if the data is in table format.I also want the graphs to be automaticaly updated.
I am trying to put some charts into a report that is pivot table based. I have some code that will work if the pivot tables stay stagnic but the users may change the tables around so that could be an issue of new data. I have the following code where I changed the source to the pivot table name (general name because of numberous report possibilites). I have taken out the other charts because they are just a variation of the chart 1. I am crashing on the line with the * on it.
Sub UWTierChart() Dim oCell As Range Dim oChart As Chart Set ws_data = ActiveSheet 'Chart 1 Sheets(wsPT).Select Range("B21").Select
I've created a worksheet with split panes. I'm able to scroll through my data vertically and horizontally while keeping one area of th screen stationary. Here's my question:
Is there a way to limit the movement of my scroll bars so that it can't move beyond the viewable portion of my worksheet? In other words, I want the scrolling to end when there is nothing else to see but a field of empty cells.
way of getting two sheets to scroll together, so when I scroll one window the other one moves too? Some text editors have that future (IIRC UltraEdit does)
I can't find a scroll event in the windows code to trigger a macro to run itself.
I can get around it by using a selection change event which would restrict me to moving around with the cursor keys/Pageup/down, but I've got 15,000 to review regularly in a short space of time and it would be quicker by mouse
[code/]Private Sub Worksheet_SelectionChange(ByVal Target As Range)
'This macro scrolls the Report to TopLeft when you click 'anywhere in the Report columns
If Target.Column > 16 And Target.Column < 22 Then With ActiveWindow .ScrollRow = 1 .ScrollColumn = 15 End With End If
If Target.Column >= 1 And Target.Column < 15 Then With ActiveWindow .ScrollRow = 1 .ScrollColumn = 1 End With
End If End Sub[code/]
...but I cant figure out how to scroll it down the list to the NextBlankRow-20 such that the previous 20 lines of data are shown to the top of the screen.
I want to return the value of E2 from sheet, "ALL INFO" and paste it in B2 on my current sheet. When I scroll this formula to right, I want the next to be the value of J2 from sheet, "ALL INFO," etc.
Ive seen on someone elses workbook the first 6 columns are fixed (always in view) then you can still scroll across but those first six columns always stay in view.
I'm having a problem working with a protected document made by another user.
The sheet has a vertical split at column F, and when I use the arrow keys to scroll right beyond this line (ie from column G and beyond), when I reach the last column (BB), it just loops straight back to the beginning (column F). This also happens in the same direction.
How I can stop this happening, so that it just stops when it reaches the end of the document?
There doesn't appear to be any coding on the sheet.
I have a spreadsheet where I want to put notes in, but I don't want to re-size the cell as it will ruin the format. The amount of information will vary from entry to entry, each entry into the sheet will have its own row and within that entry I want to dedicate one column's cell for that entry's notes. Is there anyway to make a macro for a scroll bar for individual cells so I can scroll though the text entered in that cell. I have tried a text box but the text overflows once the amount of text over fills the text box.
I want is a form that has three different partsof it. Each part containing checkboxes, a spreadsheet, textboxes and labels. But I only want to display one of these parts at a time, depending on what the user clicks. I know I could write code to move everything into the visible part of the form but that would be messy. I hoped I could find some way to instead move the visible part. Like if I had scrolled.
An example. Say the visible form is 100 high and 100 wide. When opening you see from the width 0-100 and height 0-100 (pixels or whatever those things sould be called). Upon pressing a button I instead want to see width 101-201 and height 101-201.
I have a worksheet with a column("A:A") of about 1000names. The user will start at the top and work down, entering stuff into other columns for some ofthe names. My need is: How do you automatically scroll, with code, say row 48to the top of the worksheet when the user reaches row 48 with?.
I have a sheet in which I want to limit the scrolling area to B2:B60 & D2:H60, in other words I don't want to include neither A2:A60 nor C2:C60 in my scrolling area.
Is there a way to do this?
I know I can lock the cells, however, pre-existing code will not work if cells are locked.
When the user scrolls the worksheet (using a scroll wheel, or the scroll bars) I would like to have a VBA-code triggered, but in Excel 2003 there is no "VBA-event" for scrolling...
Is there any way of trapping that a scroll has happened, even if the selection didn't change?
I have an excel sheet embedded in a Powerpoint presentation, but I have the problem that users are editing the sheet and accidently or unknowingly scrolling around. This results in the window resizing itself when the exit the object and messing up the appearance of the presentation. Is there a way of easily preventing scrolling (either via VBA or other)? I can obviously hide the scroll bars but that does not prevent the use of the mouse's scroll-wheel. I have also already hidden all unused columns and rows so that they cannot oversize the window.
What I have is a interesting task but unfortunity I am well out of my Depth so if you can help that would be GREAT.
<Snip by admin. Read the rules!> PREVENT USER SCROLLING: Some VBA code for the workbook that for all worksheets stops users from scolling outside of the set print area once it is set on.
I have graphed a range of data that was generated using VB, but the data is a series of 6 models plotted against each other over a period of 6 years and the data is daily and as such would be useful to reduce the range to look at certain periods , is it possible to do this using the mouse to select a region or would something like embeded text boxes for the ranges of dates the user could enter be better, or would it be better to move away from excel for this part of it be better. Also is it possible to plot say range A1:A5 and A20:A25 against the the relevent dates to examine two separate periods side on side.
1. I have a shared and protected workboook that about 15 people update. For some reason, when people open it they can't always scroll. Anyone know why this happens and how to fix?
2. Is there a setting so that whoever opens the workbook will see the same view (instead of whatever view the last person saved the file in)?
if it is possible to change a cell that the vlookup has found without scrolling all the way to that cell.
I have attached a small sample of my workbook. Once the vlookup has found the item I would like to change the number in G5 and make it change the number below in the OUT column that corresponds with the found item.
Example: row 11 is found with vlookup. i want to be able to change G5 to the number 8which will make G11 the number 8. And then make it stay even after i have done vlookup on another item.
I believe this will require a VBA code. Also I am using Excel 2007. I have added a test page. It is saved in 2007 format. If anyone needs it saved in 2003 please ask.
within the userform contacts, when mouse-over the image two buttons are shown.
I want when one of these buttons are it displays the next image. the names of all images for the contact are loaded in userform1 listbox. also change the name of the label1.caption.
The part im having trouble with is knowing where the current picture name is loacated within the listbox.
on a side note, if insted of using a picture object i use a activex picture viewer thing. Can i play movies within the same object as being used for the pictures.
I currently have a workbook with 6 sheets, the main worksheet has roughly 10000 rows rows (with is the one Im having trouble with) up until a few days ago scrolling wasnt to bad but just recently it is really struggling to scroll (no changes to workbook)
I have a quad core Q6600 4GB ram plenty of HDD space the excel doc size is 2.8MB
is there anything I can do to improve scrolling on large spreadsheets?
