Can someone please tell me if VBA code behind one worksheet is allowed to view code behind another worksheet? Or can VBA code behind a worksheet only view code in a module?
Asking, because, I have a dropdown on one sheet. When a selection is made, I want the change to pass the selection through code(procedure/function) that sits behind another tab..... When executing, I get an error message, eventhough I thought that I was able to perform this task in the past.
Would be great if someone could confirm, or suggest another way to handle this task.
Asking, because, I have a dropdown on one sheet. When a selection is made, I want the change to pass the selection through code(procedure/function) that sits behind another tab..... When executing, I get an error message, eventhough I thought that I was able to perform this task in the past.
Would be great if someone could confirm, or suggest another way to handle this task.
