You give no detail but this can be done with a worksheet_change event in the
sheet module

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Nick" wrote in message
...
I would like to hide/unhide columns using the column width (equal to "0").
I
would like to do this as a result of the contents of a cell. For
instance,
if user answers "Yes" to a question, then hide column D. Can this be
done?