View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ken K[_3_] Ken K[_3_] is offline
external usenet poster
 
Posts: 1
Default macro to hide columns and/or worksheets

I need some help with a macro issue....

I have a spreadsheet with multiple worksheets in it, say

"worksheet1"
"worksheet2"
"worksheet3"
"worksheet4"


I want to conditionally hide either columns or entire worksheets based on
the value of a cell in Worksheet1

For instance:

IF "Worksheet1.B17" is NULL
Then Hide columns F:K on Worksheet2
and
Hide Hide columns G:K on Worksheet3
and Hide Worksheet4

Any help would be greatly appreciated!!!!!!!!