Run the Macro if cell value is YES, else show error message.

Thanks for your quick response.

I have a few doubts:

1) How to modify the code to run within the code itself. For ex, if I am to open a sheet through macro, then my code is:

Please Login or Register  to view this content.

Similarly, I am to open the sheets through these kind of macros (buttons are in a single page). Because the users have to be restricted in activating these sheets.

2) The above doubt arises because your code is based on worksheet_change. How to apply this code if I have 10-15 macros to be called (but buttons are in a same sheet).

3) Can you please tell me if I named the range (the cell "B10" is named as "YES1"), what modification is to be done.

Thanks for your support.

acsishere

im a noob so im not sure if this is what youre looking for. yessub could be any sub, i just made a simple one. and of course this example assumes that if b10 isnt yes then its blank.

Please Login or Register  to view this content.