thomas.szwed
12-06-2007, 10:08 AM
Hi there,
I was wondering if anyone had some code to perform the operation of restricting which sheet my custom button on my custom toolbar will work with. I.E i only want one of my buttons (which runs a userform) to work on 'Sheet 1' and should the user be on 'Sheet 2' and click on the button then some sort of Msg Box appears instructing them to click on sheet 1 first. Is this possible at all?
Is it some sort of IF Statement??
Many Thanks for any help
I was wondering if anyone had some code to perform the operation of restricting which sheet my custom button on my custom toolbar will work with. I.E i only want one of my buttons (which runs a userform) to work on 'Sheet 1' and should the user be on 'Sheet 2' and click on the button then some sort of Msg Box appears instructing them to click on sheet 1 first. Is this possible at all?
Is it some sort of IF Statement??
Many Thanks for any help