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.
Bookmarks