View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Thomlinson Jim Thomlinson is offline
external usenet poster
 
Posts: 5,939
Default disable macros in a worksheet

You need to add a validation routinte to each command button that checks the
value of cell A1. Depending on the value exit sub or continue. There is no
silver bullet on this one...
--
HTH...

Jim Thomlinson


"Gordon" wrote:

Hi...

I have a workbook with 10 sheets with 15 buttons (with macros) per sheet. Is
it possible to enable/disable these buttons based on a a value entered in a
cell?

e.g. If the user enters a value into cell A1 he can begin to navigate the
workbook using the buttons/macros?

Someone must be clever out there.

Thanks

G