Thread: Hide Worksheet
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Skip[_4_] Skip[_4_] is offline
external usenet poster
 
Posts: 9
Default Hide Worksheet

Hello,

I have created a workbook with 21 worksheets. Quite often, some of the
worksheets will not be required. Is it possible to create a macro that will
look for a value in a specific cell on a worksheet (e.g. M7) and if that
cell is blank, hide the worksheet?

Grateful for any assistance.

Paul.