[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 228
  • Last Modified:

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

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
thandel
Asked:
thandel
1 Solution
 
thandelAuthor Commented:
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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now