Keep Subheaders Visible At Top Of Screen?

Apr 30, 2013

Been trying to figure out if there's a way to keep sub-headers visible at the top of the screen.

Basically I want the main headers locked at the top (via freeze panes), but then I also want certain rows, which would be sub-headings, to stick to the top of the screen until the next sub-header row gets to the top of the screen, at which point that row would replace the other one at the top.

The best example I can provide of the behavior I'm looking for is on the iPhone Contacts list. When you scroll through the contacts you see the listings, but as you scroll into each new letter that particular letter's sub-heading stays stuck at the top of the screen until you scroll down to the next letter.

So example would be:
Quantity Item Price (this would be the header row locked to the top via freeze panes)
PRODUCE
1 Apple $1
6 Orange $1
8 Pear $2
DAIRY
1 Cheese $5
7 Milk $2

So if you scrolled the above list down PRODUCE would stay at the top even while the Apple, Orange, and Pear lines scrolled off the screen, then it would get replaced with DAIRY when DAIRY reached the top of the screen.

View 1 Replies


ADVERTISEMENT

Data Analysis That Has Headers With Subheaders

Nov 20, 2009

I have student demographic data, then I have to track how each student did on each question, but each question also corresponds to a reading standard and I need to pull two pieces of info from that. How they scored on the assessment (# of answers correct), and if they missed a certain standard twice or more (There are 4 instances of StandardA in the test and they had wrong answers on 2 or more of them). I have the solution to the first part. I entered the results of each question as a 1 for correct and 2 for incorrect then did a countif and only counted the 1s. I am stumped on getting an analysis of how each student did on the indicators. Since the indicators can occur more than once, generating a pviot table doesn't work in this instance, it'll count of 1s and 2s for StandardA, StandardA2, StandardA3, etc. and not the counts of 1s and 2 for all instances of StandardA.

Example:

What I want:

For student Bob - Number of times he answered incorrectly StandardA, StandardB, StandardC, StandardD, etc.............

View 3 Replies View Related

Application Onkey: Prevent Users From Using The Print Screen Or The Alt Print Screen Buttons On The Keyboard

Dec 29, 2009

I'm just looking to prevent users from using the print screen or the alt print screen buttons on the keyboard. I have this script that works if I use "39" (Right Arrow)but wont work if I use "42" (Print Screen Button).

View 5 Replies View Related

Resize Visible Rows Based Only On Visible Columns Text

Apr 22, 2009

Need to correct code to resize all visible rows on a sheet based only on the text in the visible columns. I have tried the below code but when it resizes it is using the largest amount of text in the rows including that in the hidden columns.

View 3 Replies View Related

Multiple Checkboxes Visible Or Not Visible?

Jul 1, 2014

I have many checkboxes (1 to 26) that I want visible or not, based on whether the cell states "n/a" (are in a column in a different worksheet). Rather than writing this code multiple times, I'm looking to condense the code.

[Code] .....

View 2 Replies View Related

Copy Visible Rows And Paste To Visible Rows In Same Sheet Of Excel / VBA Code

Oct 27, 2013

I need to write a macro where i need to copy set of rows from few columns of an excel sheet to another set of columns in same sheet . My excel looks something like this...

Product
F1020
F1023
F1025
F1120
F1123
F1125

[code].....

Now when i filter this table for Product PR01 only rows 1,3,4 will be visible while the other rows remains hidden

I WANT TO COPY ROWS COMING UNDER COLUMNS

F1120
F1123
F1125

TO

F1020
F1023
F1025

when i use the code

Selection.SpecialCells(xlCellTypeVisible).Copy

i get to select ones those are visible but i am not sure how i can PASTE them to rows visible under column f1020 to f1025

Tried this in a frantic effort

Selection.SpecialCells(xlCellTypeVisible).PasteSpecial xlValues

But got an error for " multiple selection"

View 1 Replies View Related

How To Copy From Visible Cells To Visible Cells

Apr 16, 2014

Every time i do a filter and copy a data. Keep the filter on and past in another column. The data does not copy just into the visible cells. It pretend the filter is not there.

I have tried selecting only vible cells when copying and pasting into cells by selecting only visible cells but does not seem to work. Get the error message "command cannot be used on multiple section". There must be a solution but looked on the web and really cannot find one.

Table below so i filter out the "a" so i just have numbers then want to past into vible cells.

CopyPaste ResultsResults wanted
111
a2
232
a4
33
a
44

View 2 Replies View Related

2003 Is Too Far Up On The Screen

Sep 27, 2009

I did the restart our company required and when Excel reopened it was on my laptop rather than the big screen. I run 2 screens. Excel 2003 is now so far up on the laptop screen, I cannot move it. I can barely see File, Edit, View, etc. How can I drag Excel down so I can resize it?

View 4 Replies View Related

Screen Size

Dec 7, 2009

what size monitor do you use?

I'm thinking about upgrading my 17" to a 23" monitor so I can see more cells without zooming

Anyone currently use a 23" for Excel?

View 14 Replies View Related

Screen Position

Aug 18, 2009

I would like to end a macro with a specific cell (e.g. E50) in the first cell in the upper left hand corner of the screen. How might I accomplish this?

View 3 Replies View Related

Can't Get Screen To Go All Way To Top Of Page

Nov 21, 2011

I cant get my screen to go all the way to the top of the page! & there is a 2 inch or so area at the bottom of the worksheet as well. I need to get my display back to normal!

View 4 Replies View Related

Print Screen

Jul 6, 2007

macro minimizes excel takes a print screen of the application behind excel then pastes it in a word document then maximizes excel screen again

View 9 Replies View Related

Splash Screen

Nov 22, 2008

I have never created a splash screen and would like to do so now, I am in the VB editor, i have inserted a userform, i would like to insert my company logo on to the userform, how do i do this?

View 9 Replies View Related

Screen Updating

Feb 13, 2009

Is there a way to disable updating to the screen but have a message displayed to the user while a macro is running? Something like a userform displayed on the screen or a message in the status bar. I vaguley remember you could "print" message to the status bar in LotusScript, wondering if there is something similar in Excel.

Application.ScreenUpdating = False
"the macro is running, hang tight"
...macro code in here...
Application.ScreenUpdating = True

View 9 Replies View Related

Screen Refresh

Nov 18, 2009

I have a large workbook with about 20 worksheets that I have used for several years without problems. Recently, I have been getting strange behavior when the screen refreshes. The biggest problem is that I get images of other worksheets covering my current worksheet when I change a cell. I can make them go away by scrolling or flipping between another worksheet and back. I have tried using manual recalc and this has helped somewhat but I can still get the images sometimes. The workbook contains VBA that performs various tasks on every worksheet (unlock, update pivots...) but these have been in there forever. There is also one piece of code that performs advanced filtering. I can only think there was something changed with a security patch, but I wanted to know if anyone else has had this issue and might be able to provide some advice on how to prevent it.

View 9 Replies View Related

Resize Userform To Fit Screen?

Jul 20, 2013

stretch" the userform to fit the height and width fo the screen. I dont want to simply change the height and width of the userform, i want the controls within the userform to stretch with the userform so that it looks the same, just fullscreen. this is what ive found by googling:

VB:
With Application
.WindowState = xlMaximized
Zoom = Int(.Width / Me.Width * 100)
Width = .Width
Height = .Height
End With

however, this just stretches it to match the width of my screen, but doestn consider the height, so that if i have a widescreen vs a square screen it will cut off the bottom of my userform. It would be great if there was a zoom type featur that zooms the vertical and horizontal dimensions seperately... more like a stretch than a zoom.

View 2 Replies View Related

Saving An Image Of My Screen

Mar 12, 2009

I want to save an image of my worksheet, after I have right clicked, to be used in a power point presentation. How do I do that?

View 2 Replies View Related

Prevent Screen Changes During Procedure

Apr 26, 2014

I have 2 workbooks open. In the workbook that I am working in I run a macro from a userform to copy a worksheet from the other workbook that is idle in the back ground. I also display another user form that says "please wait" while the macro is running.

The problem I have is even though screen updating is set to false the screen switches over to the other workbook while it is copying the desired sheet and switches back to the workbook I am copying to after the macro completes. Also the "Please Wait" userform disappears while the other workbook is displayed and reappears when the initial workbook returns.

Below is my code which works without issue but perhaps there's a better way to copy between workbooks that would prevent the screen changes?

[Code] ........

View 3 Replies View Related

Improved Splash Screen?

Jun 5, 2014

How to get a Splash to show on WB open without seeing the Excel worksheets briefly flash before the splash loads.

(Note you will still see the Excel loading window prior to the splash appearing but I don't worry about that).

View 3 Replies View Related

VB - Timer And Screen Popup

Jul 9, 2014

I need to improve this project i've created. right now this project is an Exam for our agents. You can try it first if you want. I've attached the file below.

I need putting a timer that will compute the seconds or minutes it took the agent to finish the exam. timer should start after they click "Take the ETP" button. And finally, creating a screen / a pop-up that will show the ff example.

[I]EXAMPLE:[/I]
Name of Examinee
Answer:
1. A = Correct
2. B = Incorrect
3. A = Correct
4. C = Correct
5. D = Incorrect

Testv2.xlsm‎

View 11 Replies View Related

Create Login Screen

Mar 4, 2014

I am quite new to the excel vba. I am trying to create a login screen

So whenever i open my excel sheet, the first thing should happen is that there should be a login screen and ot should ask for password and id. Once you provide the login id and password, you would proceed to the next screen.

View 2 Replies View Related

Screen Updating Dilemma

Sep 7, 2007

I have a personal.xls macro that basically does a comparison of two different workbooks. One of these workbooks ihas it's own macros (which are there in case the user wants to run them separately)...anyways my main macro calls these other macros one at a time.

It seems that at each call, the screen updates, alternating sheets and/or workbooks....

I know about the Application.Screenupdating=True / False statements....but I am not sure where I should be putting them to get the whole thing to work seamlessly.... I tried them at the start and end of my main macro, but that doesn't do the job.

View 14 Replies View Related

Blank Screen Background

Oct 15, 2008

I use a number of user forms and would like to dsplay them with a blank background ie not over the top of the spreadsheet. The colour of a blank userform would be nice! I do not want to make them the size of the screen.

View 4 Replies View Related

Screen Movement With Macros

Oct 17, 2008

I've made quite a few programs I use in excel and have wondered about this for awhile.

When you run a macro that selects cells and objects off screen or on other sheets, the screen moves to those places. Is there anyway to lock the sheet so this doesn't happen and things look a bit more professional ?

View 9 Replies View Related

Screen Updating & Icolor

Nov 1, 2008

i have a code (Below) using icolor that changes the colour of the cell depending on critiria, the problem i have is when i input into the sheet using a drop down box the color remains the same, without a drop down box it works but i really need to to work with the drop down boxes,

View 14 Replies View Related

Message Box Appear On The Screen Only For 5 Seconds.

Nov 5, 2008

Is there a way to have a message box appear on the screen, but for only 5 seconds? and then disappear?

View 3 Replies View Related

Stopping Screen Movement

Jan 8, 2009

A good number of years ago I used a line of code at the beginning and the end of a macro to keep the spreadsheet from moving until the macro was finished. At the close it moved if a movement was necessary.

View 6 Replies View Related

Only One Sheet Full Screen?

Jan 13, 2012

I want only one sheet should in Full Screen Mode rest of the other sheets remain normal view(With Ribbon).

View 2 Replies View Related

Screen Zoom For A Workbook

Jan 24, 2013

I have just run into the situation where some users, magically and overnight , have widescreen monitors. This means the screen designs for 4:3 monitors show way too much on 16:9 monitors. I would like to put a control button on the opening page that gives them a choice of zoom, which usually seems to be 100% and 135%.

I'm thinking probably an IF sequence to parse their response and execute the appropriate zoom. But how can I make it effective for all the sheets in a workbook?

View 9 Replies View Related

Screen Updating Off But Still Updates

Jun 20, 2013

I have a macro that opens many excel documents. I used the application.screenupdating to turn off viewing these excel documents opening unfortunately they are still viewable. I counted the number of trues and falses in the module and there are 4. I believe the 2 pairs are unrelated. I keep both subs in the same module since they share functions.

Code:
Application.ScreenUpdating = False 'turbospeed
Debug.Print Application.ScreenUpdating 'shows true in break mode

View 9 Replies View Related







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