Code Error when another Excel document is open

Evening all,

The below code keeps breaking at the first line. I don't have the issue when on my PC but when passed to users, who have other excel documents it throws an error all the time. I have tried having other documents open but cannot replicate.

StrName is just looking to land them back on the right tab based on the day in F2 ( Monday to Friday ) matching tab names.

The issue I also have is that I struggle to know how to call the actual workbook (Which I thought might stop the issue) as it could be 'Week 1' 'Week 2' ........ 'Week 5'. This is consistent though so naming convention wont change.

Please Login or Register  to view this content.

Hi Richard,

Thank you for looking over.

As the spreadsheet relates to my work I would struggle to put in onto here, redacting it would probably mean it doesn't work

F2 contains

Please Login or Register  to view this content.

in order that at the end I can drop the user back to the tab that relates to the right day.

I think it has to with other sheets being open and therefore it cant find F2 on that tab as it wont exist on the other file they look at !?

This seems to have sorted it, Thank you for your help !

Originally Posted by xlnitwit

Hi,

You could skip the cell reference altogether and use

Please Login or Register  to view this content.