Hi Kurtis, You pretty well have it, I can fix the row and column titles but I also want to be able to scroll left and right a specific number of columns each time so that date information is guaranteed to line up under the day title.
Unlike most calendar implementation I need to be able to see the week right across the week and I need to be able to double book some time slots and vary them if necessary. I need to carry some other information too but I think I can do this using a hyperlink or pull down ComboBox to minimize on screen real estate. It is the pane or block of data I wish to be able to shift a fixed and specified number of columns and it must be reliable. Thanks for that title info, I knew about it but also forgot about it. Dale Leavens, Cochrane Ontario Canada [EMAIL PROTECTED] Skype DaleLeavens Come and meet Aurora, Nakita and Nanook at our polar bear habitat. ----- Original Message ----- From: "KURTIS POTTER" <[EMAIL PROTECTED]> To: <jaws-users-list@jaws-users.com> Sent: Tuesday, September 25, 2007 7:47 AM Subject: Re: [JAWS-Users] Moving pane in Excel? > What I think you want is for the Row and Column titles to stay fixed on > the screen so that no matter how far left or right you scroll this > information is visible (at least for sighted users). If that is what > you want it can be done in Excel, I used to do this when I was sighted, > but I used the mouse to do it and haven't found the proper menu option > yet. But I am still looking. > If on the other hand, you do not care if the information is visible or > not, but you want JAWS to speak the Row and Column titles then do this: > 1 Place your cursor to the left of the first Column title and above the > first Row Column. So if your Column titles began in B1 and Row Titles > in A2 your cursor should be in A1. > 2 Press alt I for the insert menu. > 2 Press N for Name. > 3 Press D for Define. (this should open a dialog box and put you in an > edit field). > 4 type "Title" (be sure the T is capital). > 5 Press Enter. > > Now when you arrow left or right JAWS should say the column title and > when you arrow up and down JAWS should say the ROW title. Be sure to > save the file after doing this as this information is stored in excel. > > I hope this works for you. I will keep looking for the way to do this > visually. I know it is out there. > Let me know if you have any questions. > > >>>> [EMAIL PROTECTED] 09/24/2007 7:56 PM >>> > I don't know for sure that it can! > > It might be that I have to do it with V B A or possibly by recording a > macro then modifying it to respond to some selected key strokes.. > > Dale Leavens, Cochrane Ontario Canada > [EMAIL PROTECTED] > Skype DaleLeavens > Come and meet Aurora, Nakita and Nanook at our polar bear habitat. > > > ----- Original Message ----- > From: "Patricia" <[EMAIL PROTECTED]> > To: <jaws-users-list@jaws-users.com> > Sent: Monday, September 24, 2007 8:04 PM > Subject: Re: [JAWS-Users] Moving pane in Excel? > > >> Wow, didn't know Excel could do that... >> >> ----- Original Message ----- >> From: "Dale Leavens" <[EMAIL PROTECTED]> >> To: <jaws-users-list@jaws-users.com> >> Sent: Monday, September 24, 2007 6:54 PM >> Subject: Re: [JAWS-Users] Moving pane in Excel? >> >> >>> No, I want to scroll the displayed sells a fixed number of positions > left >>> or right. Imagine a roll of paper with a week of dates showing > through a >>> square. You roll the strip one increment and the next series shows > through >>> the window. >>> >>> Dale Leavens, Cochrane Ontario Canada >>> [EMAIL PROTECTED] >>> Skype DaleLeavens >>> Come and meet Aurora, Nakita and Nanook at our polar bear habitat. >>> >>> >>> ----- Original Message ----- >>> From: "Patricia" <[EMAIL PROTECTED]> >>> To: <jaws-users-list@jaws-users.com> >>> Sent: Monday, September 24, 2007 7:42 PM >>> Subject: Re: [JAWS-Users] Moving pane in Excel? >>> >>> >>>> Are you wanting to copy and paste rows and columns somewhere else > in >>>> excel? >>>> >>>> If so, the shift-spacebar is the copy command for a row and >>>> control-spacebar >>>> is the copy for a column. >>>> you also can hold down the shift key like with your left hand and > use the >>>> right/left arrow keys to select blocks of text to move elsewhere as > well. >>>> One thing to note...if you use any kind of dollars/cents which you > can >>>> copy >>>> and paste into anotehr cell, it tends to show as ### sign to get > your >>>> copied >>>> info to show up just widen your cell... >>>> >>>> Patricia >>>> ----- Original Message ----- >>>> From: "Dale Leavens" <[EMAIL PROTECTED]> >>>> To: <jaws-users-list@jaws-users.com> >>>> Sent: Monday, September 24, 2007 6:09 PM >>>> Subject: [JAWS-Users] Moving pane in Excel? >>>> >>>> >>>>> There seems to be something wrong with the help system for MS > Office on >>>>> this computer making me really struggle to figure things out. > Maybe this >>>>> cannot be done but hopefully it can and someone knows how. >>>>> >>>>> In Excel 2000 I want to keep the top column titles fixed and the > left >>>>> row >>>>> titles fixed. I seem to have figured that out but now I want to > move the >>>>> adjacent block left and right by a fixed number of cells. >>>>> >>>>> What I am trying to make happen is a list of times down the left > side >>>>> and >>>>> days across the top and with a keystroke or mouse dropping get > the day >>>>> information to shift left and right one week at a time. >>>>> >>>>> If anyone knows that this can be done I will struggle with the > help to >>>>> find it. better still a description of how would be really nice. >>>>> >>>>> All I seem to be able to get out of the Help system is the intro > page >>>>> about how to get help from the Office Assistant and so on, nothing > seems >>>>> to persuade this machine to give up that answer wizard which lets > you >>>>> type >>>>> in a question. It does work a little better some of the time on > the >>>>> computer at work but I don't have time to play with these ideas > there. >>>>> >>>>> Apologies if this question is sailing a little close to the edge > of "on >>>>> topic" for this list, I appreciate it to be an arguable point. >>>>> >>>>> Dale Leavens, Cochrane Ontario Canada >>>>> [EMAIL PROTECTED] >>>>> Skype DaleLeavens >>>>> Come and meet Aurora, Nakita and Nanook at our polar bear > habitat. >>>>> >>>>> Visit the JAWS Users List home page at: >>>>> http://www.jaws-users.com >>>>> Address for the list archives: >>>>> http://www.mail-archive.com/jaws-users-list@jaws-users.com >>>>> To post to this group, send email to >>>>> jaws-users-list@jaws-users.com >>>>> To unsubscribe from this group, send an email to >>>>> [EMAIL PROTECTED] >>>>> For help from Mailman with your account Put the word help in the > subject >>>>> or body of a blank message to: >>>>> [EMAIL PROTECTED] >>>>> Use the following form in order to contact the management team >>>>> http://www.jaws-users.com/managers.php >>>>> If you wish to join the Blind Computing list send a blank email to > the >>>>> following address: >>>>> [EMAIL PROTECTED] >>>> >>>> >>>> Visit the JAWS Users List home page at: >>>> http://www.jaws-users.com >>>> Address for the list archives: >>>> http://www.mail-archive.com/jaws-users-list@jaws-users.com >>>> To post to this group, send email to >>>> jaws-users-list@jaws-users.com >>>> To unsubscribe from this group, send an email to >>>> [EMAIL PROTECTED] >>>> For help from Mailman with your account Put the word help in the > subject >>>> or body of a blank message to: >>>> [EMAIL PROTECTED] >>>> Use the following form in order to contact the management team >>>> http://www.jaws-users.com/managers.php >>>> If you wish to join the Blind Computing list send a blank email to > the >>>> following address: >>>> [EMAIL PROTECTED] >>>> >>> >>> Visit the JAWS Users List home page at: >>> http://www.jaws-users.com >>> Address for the list archives: >>> http://www.mail-archive.com/jaws-users-list@jaws-users.com >>> To post to this group, send email to >>> jaws-users-list@jaws-users.com >>> To unsubscribe from this group, send an email to >>> [EMAIL PROTECTED] >>> For help from Mailman with your account Put the word help in the > subject >>> or body of a blank message to: >>> [EMAIL PROTECTED] >>> Use the following form in order to contact the management team >>> http://www.jaws-users.com/managers.php >>> If you wish to join the Blind Computing list send a blank email to > the >>> following address: >>> [EMAIL PROTECTED] >> >> >> Visit the JAWS Users List home page at: >> http://www.jaws-users.com >> Address for the list archives: >> http://www.mail-archive.com/jaws-users-list@jaws-users.com >> To post to this group, send email to >> jaws-users-list@jaws-users.com >> To unsubscribe from this group, send an email to >> [EMAIL PROTECTED] >> For help from Mailman with your account Put the word help in the > subject or body of a blank message to: >> [EMAIL PROTECTED] >> Use the following form in order to contact the management team >> http://www.jaws-users.com/managers.php >> If you wish to join the Blind Computing list send a blank email to > the following address: >> [EMAIL PROTECTED] >> > > Visit the JAWS Users List home page at: > http://www.jaws-users.com > Address for the list archives: > http://www.mail-archive.com/jaws-users-list@jaws-users.com > To post to this group, send email to > jaws-users-list@jaws-users.com > To unsubscribe from this group, send an email to > [EMAIL PROTECTED] > For help from Mailman with your account Put the word help in the > subject or body of a blank message to: > [EMAIL PROTECTED] > Use the following form in order to contact the management team > http://www.jaws-users.com/managers.php > If you wish to join the Blind Computing list send a blank email to the > following address: > [EMAIL PROTECTED] > > Visit the JAWS Users List home page at: > http://www.jaws-users.com > Address for the list archives: > http://www.mail-archive.com/jaws-users-list@jaws-users.com > To post to this group, send email to > jaws-users-list@jaws-users.com > To unsubscribe from this group, send an email to > [EMAIL PROTECTED] > For help from Mailman with your account Put the word help in the subject or > body of a blank message to: > [EMAIL PROTECTED] > Use the following form in order to contact the management team > http://www.jaws-users.com/managers.php > If you wish to join the Blind Computing list send a blank email to the > following address: > [EMAIL PROTECTED] > Visit the JAWS Users List home page at: http://www.jaws-users.com Address for the list archives: http://www.mail-archive.com/jaws-users-list@jaws-users.com To post to this group, send email to jaws-users-list@jaws-users.com To unsubscribe from this group, send an email to [EMAIL PROTECTED] For help from Mailman with your account Put the word help in the subject or body of a blank message to: [EMAIL PROTECTED] Use the following form in order to contact the management team http://www.jaws-users.com/managers.php If you wish to join the Blind Computing list send a blank email to the following address: [EMAIL PROTECTED]