View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
John Baker John Baker is offline
external usenet poster
 
Posts: 98
Default Proteting against a button press

Hi:

I have a spreadsheet containing buttons which activate macros. I want to protect one
sheet in the workbook so that no one can write on it, and no one can activate the buttons
without a password. When I protect sheet, I find that while the cells are protected the
button can be activated.

Can someone tell me how to set the BUTTONS so that they cant be pressed and activate the
macros.

Thanks a lot

JOhn Baker