View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
wx4usa wx4usa is offline
external usenet poster
 
Posts: 122
Default Re-post: Code to make sheet very hidden based on date

I need some code to hide a sheet if a date has past. Date is in Cell
a1 of sheet 1 and sheet 2 needs to be very hidden. I would rather
not use regular conditional formatting since formats can be copied and
pasted thus changing cell formats.

I would like to make the worksheet very hidden if possible.

If you can provide the code, please tell me where to paste it. I am
new to VB for Excel

Thanks