I have an excel application that I'm developing that is going to be used by two different departments. On one side everything will pretty much be userforms. The sheets they the data I need to pull in for them is on sheets that I have such that their visibilty is equal too xlveryhidden.
I'm trying to change the captions on labels using the data on the veryhidden sheets. Something like this.
The labels are not changing their values.
I hope this makes sense.