Search results for query: *

I'm having trouble with a script which is triggered by the Change event of the worksheet. Essentially, what the script does is a simple data validation process and then rounds the result. The problem I'm having is that it is circular and executes ad nauseum. Is there any simple way to isolate...

Hi! I've got a problem that's got me stumped. I was hoping to figure out a way to "trap" the event as a user pastes into an Excel worksheet. I'd like to be able to gracefully reverse the paste and present the user with an informative dialog box. Alternatively, I can live with a...

Thanks for the responses, guys/gals . In actuality I do need to get a handle on each instance of Excel because I absolutely can have only one instance of my Excel worksheet (which is created from a Domino document) running because it is receiving contextual data from a local environment string...

Hi all! I'm writing a VBA script which launches an Excel worksheet from within another application (Lotus Notes). The problem I'm having is that I want to lock down the script so that it only opens one instance of Excel, no matter how many times the user launches it. To do this, I'm pretty...

Hi all! I'm developing an Excel worksheet to act as something of a custom control and in so doing am disabling all command bars and then re-enabling them using the following code in the workbook Open event: For Each menuOption In Application.CommandBars 'Suppress all the command bars...