Re: Moving between one sheet to another in Protected sheets

1 view
Skip to first unread message
Message has been deleted

Pankaj Sharma

unread,
Dec 5, 2015, 2:37:17 AM12/5/15
to Excel VBA Lab
Is there any solution to move between one sheet to another with keyboard shortcut ( Ctrl + Pageup and Page Down) in protected worksheet ??





On Saturday, December 5, 2015 at 1:03:33 PM UTC+5:30, Pankaj Sharma wrote:
Dear team,

Is there any solution to move between one sheet to another in protected worksheet ??





Ashish Kumar

unread,
Dec 5, 2015, 2:52:23 AM12/5/15
to Excel VBA Lab
Dear Pankaj,

If you want to move from Sheet1 to Sheet2 then use Cntrl + Pageup and Pagedown

or

If you want to move from one worksheet to another worksheet then use Cntrl + Tab.


Regards
Ashish Kumar

Pankaj Sharma

unread,
Dec 5, 2015, 8:50:57 AM12/5/15
to Ashish Kumar, Excel VBA Lab
Dear Ashish,

Please i am asking about Protect worksheet. For example please find attachment. 

In Protected sheets, Ctrl+ Page Up and Down has not been worked.


aside  Vabv, Paul and Mandeep,, .please share if there is any way to resolve this.





Pankaj Sharma                                                  
MIS Analyst

Greater Kailash-1, New Delhi
Email   pankaj...@gmail.com
Skype   pankaj.sharma_pj



--
www.ExcelVbaLab.com
---
You received this message because you are subscribed to a topic in the Google Groups "Excel VBA Lab" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/ExcelVbaLab/9LGE6INH_M8/unsubscribe.
To unsubscribe from this group and all its topics, send an email to ExcelVbaLab...@googlegroups.com.
To post to this group, send email to Excel...@googlegroups.com.
Visit this group at http://groups.google.com/group/ExcelVbaLab.
To view this discussion on the web visit https://groups.google.com/d/msgid/ExcelVbaLab/c3e24552-42d2-4f9f-8f9c-57e571b7670b%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Protect Sheet.xlsx

Pankaj Sharma

unread,
Dec 5, 2015, 12:31:37 PM12/5/15
to Ashish Kumar, Excel VBA Lab
Sorry guys, wrong file attached. now please file attached example file.



Pankaj Sharma                                                  
MIS Analyst

Greater Kailash-1, New Delhi
Email   pankaj...@gmail.com
Skype   pankaj.sharma_pj



Example File.xlsx

Ashish Kumar

unread,
Dec 7, 2015, 8:54:22 AM12/7/15
to Excel VBA Lab
Dear Pankaj,

Sheet is working perfect in my machine.

I am able to move sheet 1 to sheet 2 with the help of Cntrl + Pageup and Pagedown. Check the attached Images.


Regards
Ashish Kumar




Y1.JPG
y2.JPG
y3.JPG

Pankaj Sharma

unread,
Dec 7, 2015, 2:51:41 PM12/7/15
to Ashish Kumar, Excel VBA Lab
First thanks for replying Ashish,,, 

As i can see here you are using excel 2010 or 2013 and with this file Ctrl+Page up and down command is not working in Excel 2007 just because of protection.

Thanks once again...




Pankaj Sharma                                                  
MIS Analyst

Greater Kailash-1, New Delhi
Email   pankaj...@gmail.com
Skype   pankaj.sharma_pj



--
www.ExcelVbaLab.com
---
You received this message because you are subscribed to a topic in the Google Groups "Excel VBA Lab" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/ExcelVbaLab/9LGE6INH_M8/unsubscribe.
To unsubscribe from this group and all its topics, send an email to ExcelVbaLab...@googlegroups.com.
To post to this group, send email to Excel...@googlegroups.com.
Visit this group at http://groups.google.com/group/ExcelVbaLab.
To view this discussion on the web visit https://groups.google.com/d/msgid/ExcelVbaLab/8ecccc71-8e68-4a93-a9f2-b3c34e50843f%40googlegroups.com.

Ashish Kumar

unread,
Dec 7, 2015, 11:04:04 PM12/7/15
to Excel VBA Lab
Welcome...!


Regards
Ashish Kumar
Reply all
Reply to author
Forward
0 new messages