Vertical Scroll not working. Excel -


i have excel sheet attempting have scroll bar show 10 of possible hundreds of items on list. created scroll bar, had reference field, calculations. each field scroll bar interacts referenced off field well. can't imagine why it's not working.

what happening when scroll bar , down text right of doesn't move. i'd know if computer, or not. if computer need make work? use vba , may of accidently disabled allow scrolling not work, don't know.

can please?

here worksheet in question.

https://dl.dropbox.com/u/3327208/excel/scrollnotworking.xlsx

your calculation set manual.

do this. under

formulas tab click on calculation options , on automatic

now try it

enter image description here

followup

sweet perfect, there way in vba make happen? have go through code , find out if there spot makes manual... because think there is. – matt ridge 1 min ago

there 2 reasons why calculation switches manual via vba

1) set manual , forget set back. example

sub sample()     application.calculation = xlcalculationmanual      '~~> rest of code end sub

2) set manual in beginning , set automatic in end still remains manual. happens because didn't include proper error handling because of code exits prematurely procedure. see example

the wrong way

sub sample()     application.calculation = xlcalculationmanual      '~~> rest of code      application.calculation = xlcalculationautomatic end sub

the preferred way

sub sample()     on error goto whoa      application.calculation = xlcalculationmanual      '~~> rest of code  letscontinue:     application.calculation = xlcalculationautomatic     exit sub whoa:     msgbox err.description     resume letscontinue end sub

note: if want, can store current state of calculation , set @ end of code if want to.


Comments

Post a Comment

Popular posts from this blog

java - Play! framework 2.0: How to display multiple image? -

i need display gallery of photos. here template: @(photos: list[photo]) @title = { <bold>gallery</bold> } @main(title,"photo"){ <ul class="thumbnails"> @for(photo <- photos) { <li class="span3"> <a href="#" class="thumbnail"> <img src="@photo.path" alt=""> </a> </li> } </ul> } and here controller method: public static result getphotos() { return ok(views.html.photo.gallery.render(photo.get())); } and here photo bean : @entity public class photo extends model { @id public long id; @required public string label; public string path; public photo(string path, string label) { this.path = path; this.label = label; } private static finder<long, photo> find = new finder<long, photo>( long.class, photo.class); public static list<phot...
Read more

gmail - Is there any documentation for read-only access to the Google Contacts API? -

i want read-only access user's google contacts. there stackoverflow member wanted this, , received following answer : yes, there is, use https://www.googleapis.com/auth/contacts.readonly scope , "view contacts". this exchange reference read-only access google contacts can find using google. simply using access token obtained attempt read usual google contacts api (i.e. https://www.google.com/m8/feeds ) fails insufficient permissions. similarly, using google contacts api on new target fails 404 errors (for example https://www.googleapis.com/auth/contacts.readonly/default/full ). is there documentation anywhere on how use api, or permissible way access google contacts api full read-write access?
Read more

php - Controller/JToolBar not working in Joomla 2.5 -

relevant code: jtoolbarhelper::custom('savecategories', 'save', '', 'save', false, false); ... <input type="hidden" name="controller" value="easyblogcontroller"> according can dig docs , own previous questions, should call savecategories() function in easyblogcontroller . i've tried setting value easyblog , easyblog.php (file name) current easyblogcontroller (class name). clicking on save button refreshes page. not redirect, echo or var_dump test code put in savecategories() function. var_dump ing jrequest::getvar('controller') , 'task' return correct values. creating controller object , using $controller->execute('task'); works. the values going depend on location of controller trying call, , have couple options here. typically there controller in base folder of component (likely components/com_easyblog) in file called controller.php , class name inside ...
Read more