Solved

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

Posted on 2011-09-29
1
216 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

Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

Join & Write a Comment

A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
Drop Down List with Unique/Distinct Values (enhancing the Combo-Box with a few steps and a little code) David miller (dlmille) Intro Have you ever created a data validation list from a database field or spreadsheet column (e.g., Zip Codes or Co…
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…

706 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

20 Experts available now in Live!

Get 1:1 Help Now