Solved

Control Page up/down doesn't move to other sheet

Posted on 2011-09-29
1
217 Views
Last Modified: 2012-05-12
Using Excel 2003 wth XP SP3.... I have one workbook that is function correctly in that pressing CNTRL Page Up/Down moves to the next/prior worksheet.  I have another Excel worbook that pushing the same buttons acts like I'm only pushing Page Up/Down.

Is there a setting per workbook to get this behavior to work correctly?
0
Comment
Question by:thandel
1 Comment
 

Accepted Solution

by:
thandel earned 0 total points
ID: 36817954
Disregard... found it... "EnableRestrictions" was to xlUnlockedCells.... I changed it to Norestricted and all is working correctly.  I just bumped into that by mistake.  Go figure, would never have guessed.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Dealing with unintended Excel Active-X resizing quirks (VBA code simulates "self correction") David Miller (dlmille) Intro Not everyone is a fan of Active-X controls in spreadsheets (as opposed to the UserForm approach, the older Form controls …
Approximate matching with VLOOKUP and MATCH seems to me to be a greatly under-used technique, and one which is vital for getting good performance out of large lookups. Until recently I would always have advised using an exact match for simplicity an…
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.

910 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now