Hi there,
I have encountered a very frustrating problem. For some reason my most beloved shortcut control + page up/down has stopped working so I can easily switch between tabs. I have no idea why! All other shortcuts work as they should. I've googled around but I haven't found any solution that remedies this so it doesn't seem super common.
Has this happened any of you?
Thanks
Is this for all files or just one file?
(In 2007, if a sheet was protected and the option to allow users to selected locked cells was not selected, then that locked the tab as well, stopping you from using Ctrl-PgUp/Dn to navigate away from it. But that's not the case in 2010.)
Regards,
Aardigspook
I recently started a new job so am a bit busy and may not reply quickly. Sorry - it's not personal - I will reply eventually.
If your problem is solved, please go to 'Thread Tools' above your first post and 'Mark this Thread as Solved'.
If you use commas as your decimal separator (1,23 instead of 1.23) then please replace commas with semi-colons in your formulae.
You don't need to give me rep if I helped, but a thank-you is nice.
It's for all files.
I have Excel 2016 and it's super strange... I can't find what is causing it.
Is there a macro in the workbook that disables these key combinations?
For Searching In which file above micro save.PHP Code:Private Sub Workbook_Activate()
Application.OnKey "^{PgDn}", ""
Application.OnKey "^{PgUp}", ""
End Sub
>Go to "Start" & search
>Click on "All files and folders"
>In "A word or phrase in the file : Enter required number i.e. Application.OnKey "^{PgDn}", ""
>In look in : choose folder. (if you know exact folder name kindly go through "browse"
>click on "Search" tab.
atul
If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.
Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks