Help with Working Rota

Hi all,

I've been working on this rota with excelliot.com but he isn't reachable right now and i just need help with a few quick changes.

Firstly whenever i make a shift change EG i changed Rebecca on tuesday 21st from a 7-1 to a 7-4 it then takes me to the tuesday work sheet. Is there a way i can stop it from doing this?

Thanks in advanced !






!Work rota 25.xlsb VER 3 (8).xlsb

It's built into the VBA, so you would have to remove the part of the code which tells it to go to the sheet when the table is changed.

I've looked for that part of the code it should look something like

application.goto line

But i can't seem to find it anywhere in the code

There is some code called Worksheet_Change which is making this happen. To remove it, go into the VBA editor, double click on 'Sheet1 (rota)' within 'Microsoft Excel Objects' and set the two dropdowns at the top to 'Worksheet' and 'Change' respectively. Then delete everything before the first line break. Might be a good idea to save the code in notepad or something just in case anything goes wrong.

Either i'm not understanding or its just not working, I have plenty of copy's of the spreadsheet so no problem if it get messed up. Any other ideas?

Which bit didn't you understand? Did you find the code I was referring to?

This is the section you need to delete.

Please Login or Register  to view this content.

If i delete that then that remove a core part of what im trying to achieve with this spreadsheet if you notice C17 to O17 there are numbers, these are the numbers that represent how much hours i need to deploy to cover a shift that code was dynamically updating that number.

But atleast now we have found out that its somewhere in that code that's forcing me to go to the sheet where i just updated the shift.