Lock A Textbox From Moving While Scrolling
Aug 14, 2006
I know it's possible to lock objects (textboxes), via their properties. ( ie: to move or not with cells),
However, I'm trying to lock down a textbox so that when I scroll the main window, the entire page scrolls except the textbox, which remains in it's position.
A quick solution would be to freeze/split this area... but part of my work area is already utilizing a frozen partition.
I don't believe there is a way to freeze multiple areas.. or is there?
how to prevent a textbox from moving?
View 9 Replies
ADVERTISEMENT
Jun 12, 2007
I have assgined a group of object to run Macro's. Each object has it's own Macro. The part I am missing is that when I move through the Excel data the object should move too. The group of Object should be visible even if I work in row 1 or row 100000?
View 6 Replies
View Related
Apr 6, 2009
i like to block scroling the screen upto A1:A31?
View 5 Replies
View Related
Jun 16, 2008
Will excel allow text to be permanently be positioned in a specific cell even if rows or columns are added?
View 6 Replies
View Related
Feb 28, 2014
Can we lock or disable text box editing in excel without protecting sheets?
View 1 Replies
View Related
Dec 19, 2006
I have a form in a workbook that has macros attached via buttons. The intention is that as you hit the revise button it creates a virtually identical sheet, renaming it as a copy in the same workbook, clearing certain fields...etc...I then have it "lock/protect" the previous revision sheet so the history can't easily be corrupted. Everything works with the exception of the forms textbox...it won't lock (more to the point I can't figure out how to lock it). Can you protect a forms textbox even?
View 2 Replies
View Related
Jun 22, 2007
I have a TextBox on a UserForm and I want to validate the user's input as soon as he moves focus from the TextBox but before he selects OK. I have the validation function, but what is the event
View 5 Replies
View Related
Sep 23, 2013
I have an excel work book with 6 tabs. I would like to have Excel move an entire row from one tab to another tab (removing the row and inserting it in the other tab). I.e. Example I have a tab with items that are marked as "Open Actions" so if I were to change the drop down to close. Excel would move that entire row of actions to the tab with the "closed actions" and insert into the next available row. Now if someone were to come back at a later date say no it should be reopened than I would change the drop down to open and excel would move that row back to the open actions tab into next available row. I tried a PIVOT table and no good I played with few macro and not.
View 5 Replies
View Related
May 18, 2006
I am attempting to format some TextBoxes from within a For/Next loop. I need a way to check which TextBox is the active TextBox in the loop. Using i as the variable, I came up with this code snippet: Me.Controls("TB" & i).Text = Format("TB" & i, "mm/dd/yy")
If i = 3, this gives me in TextBox3 (which is called TB3) the text 'TB3' and not the value of what is in TB3. It has got to bo something simple, I just can't see it!!!
View 2 Replies
View Related
Nov 30, 2008
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.
View 11 Replies
View Related
Nov 6, 2007
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
View 9 Replies
View Related
Mar 18, 2008
[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.
View 9 Replies
View Related
Jul 14, 2008
Is it possible to use a macro that do the following:
scrolling, only the used range + 1
So if the used range is B2:D12 then the scrolling is possible to row 13 and column E
View 9 Replies
View Related
Jul 2, 2009
do you know if there is vba code to lock formulas so someone sees but does not touch and the same for values see but cant change??
my sheets with formulas are SUMMARY and Sheet2
sheet with value is TABLE
View 9 Replies
View Related
Apr 26, 2014
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.
View 2 Replies
View Related
Feb 10, 2009
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.
View 3 Replies
View Related
Dec 18, 2009
I'm looking to disable the horizontal and vertical scrolling in 1 worksheet
Am i able to do this?
View 5 Replies
View Related
Feb 2, 2014
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.
View 1 Replies
View Related
Jul 5, 2014
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.
View 4 Replies
View Related
Nov 17, 2009
i want to know whether there is any way to make an MouseWheel-Event in VBA (Excel 2003) and send it to the scrollBars of my UserForm?
View 3 Replies
View Related
Feb 1, 2010
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.
View 5 Replies
View Related
Dec 1, 2011
I am sure this has been asked -and answered- before.
I need to select a cell, e.g. C1000, and change the view, so that I see C1000 on top of my spreadsheet.
range("C1000").select clearly does not accomplish what I want.
View 4 Replies
View Related
Dec 30, 2011
What is the vba code to disable scrolling Up or down?
View 1 Replies
View Related
Nov 9, 2012
Is there a way to limit the number of columns and rows that a user will see and therefore limit the scrolling in a spreadsheet?
View 6 Replies
View Related
Jul 28, 2013
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?.
View 2 Replies
View Related
May 29, 2008
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.
View 9 Replies
View Related
Sep 17, 2008
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?
View 9 Replies
View Related
Oct 28, 2006
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
View 4 Replies
View Related
Oct 19, 2007
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.
View 5 Replies
View Related
Dec 7, 2007
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.
View 4 Replies
View Related
