Can Worksheet code see worksheet code?

atf32

Board Regular
Joined
Apr 13, 2011
Messages
157
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?:confused:

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.
 

Some videos you may like

Excel Facts

What does custom number format of ;;; mean?
Three semi-colons will hide the value in the cell. Although most people use white font instead.

Watch MrExcel Video

Forum statistics

Threads
1,099,618
Messages
5,469,732
Members
406,668
Latest member
ElizaR

This Week's Hot Topics

Top