View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Rick Rothstein Rick Rothstein is offline
external usenet poster
 
Posts: 5,934
Default disable macros in a worksheet

You did mean CommandButton when you said "button", right?

Which "buttons" did you use... the ones from Form's toolbar or the Control
Toolbox toolbar?

--
Rick (MVP - Excel)


"Gordon" wrote in message
...
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