Grouping sheets without use of shift or control key (LogMeIn problems)

[jesperaudi]

I have used Logmein Free for 5+ years and always found it great for most purpsoes. There were some issues (like the way files opened in windows explorer) that seem to have gone away.

The main issue that stops me working in Excel at home on my work files are when I need to work in group mode ie make changes to more than one worksheet at the same time.

I find I cannot enter group mode.

I would ordinarily click on one tab, press shift then click on another and any sheet inbetween these two would be grouped. This does not appear to work when connected remotely. Similarly, the Ctrl key will not allow me to add one sheet at a time, or if I use Select all sheets the control key does not allow me to deselect.

Does anyone else recognise this problem?

Does anyone else know another way to group sheets that perhaps does not involve use of the shift or ctrl key like this? or any other workarounds?

Many thanks in advance, Jesper

 

[Pup Denab]

HI Jesperaudi

See link below, looks like some else has already found a solution using vba
Regards
Pup

http://www.mrexcel.com/forum/excel-...rksheets-using-visual-basic-applications.html

 

[jesperaudi]

Hi thanks for that, Pup

I will definitely try it.
The thing is I use group mode so much, the sheets are not always consecutive, so I am hoping that one day, I just try it and my shift and control keys work in Logmein.
If there are any other workarounds just using the stanadrd keyboard, that would be wonderful

Cheers Jesper