View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Luke M Luke M is offline
external usenet poster
 
Posts: 2,722
Default using a toggle button to show or hide information in several cells

If the information is a whole row/column, you could record of macro of you
hiding the rows, and unhiding the rows (seperate recordings, of course)

Then just assign the macros to two buttons

--
Best Regards,

Luke M


"hanson" wrote:

I have a sheet that contains confidential information and only want it
visible when I need it. I can insert all the different buttons and boxes but
can not seem to get them to do this.