Is there any simple way to pass a text string as an argument to a VB function which will be obeyed as a VB instruction? For example ObeyText("Text","FAIL Text") where "FAIL Text" would be returned if the execution of "Text" actually failed (rather than normal error handling).
The reason for my request is that sheet protection has changed in 2003, and I have a legacy library of routines in Macro 4 language. It provides a programmer interface and I wish to enhance it so that my user passes text down to me and I pass it to this function. My Visual Basic is very weak!! My proposed approach would allow me flexibility with other changes.