NBVC
Well-known Member
- Joined
- Aug 31, 2005
- Messages
- 5,828
Can someone help with an error-handling code for the following please:
I have a custom macro button in the toolbar. If the user clicks that button when there is no worksheet loaded at all (ie. when Excel is just opened), then I would like a message to pop up to alert them of that instead of getting an error message and asking them to debug the code.
The button is linked to a macro in personal.xls
Thanks.
I have a custom macro button in the toolbar. If the user clicks that button when there is no worksheet loaded at all (ie. when Excel is just opened), then I would like a message to pop up to alert them of that instead of getting an error message and asking them to debug the code.
The button is linked to a macro in personal.xls
Thanks.