View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] alpine7411@hotmail.com is offline
external usenet poster
 
Posts: 11
Default Hiding a From Button

I have a spreadsheet that has 7 different sheets. In each sheet there
are 6 From Buttons that activate Macro's. All the sheets are locked
with the exception of a few unprotected cells (where they can enter
there data). I've locked 3 of the Form Buttons so that you have to
unlock the sheet to use the buttons. Is there a way so that once I
lock the sheet the 3 From Buttons dissappear and when I unlock the
sheet they reappear? I'm not sure where to even start with this one.

Thanks,
Keith