guys hoping someone can help out...
ive got some sheet code that changes the interior colors of some cells. which works just fine but doesnt run until the user enters any value into the sheet. how can i make it work witout having to have entered anything. maybe when the sheet becomes active??? also one more question i have a command button that executes a list of things when clicked how can i make it ask the user "Are you sure" yes or no ???
any help is appreciated
thank you
ive got some sheet code that changes the interior colors of some cells. which works just fine but doesnt run until the user enters any value into the sheet. how can i make it work witout having to have entered anything. maybe when the sheet becomes active??? also one more question i have a command button that executes a list of things when clicked how can i make it ask the user "Are you sure" yes or no ???
any help is appreciated
thank you