View Single Post
  #5   Report Post  
ditchy
 
Posts: n/a
Default

Hi BoB
I like this option
(((( Application.CommandBars("Works=ADheet Menu
Bar").Controls("Format").Contr=ADols("Sheet").Cont rols("Unhide.=AD..").Enab=
led
=3D
True )))

but I need it to hide the format/sheets/toolbar on open,
then unhide the format/sheets/toolbar on close
not sure which way to go about it?
I have a macro that will unhide sheets when a password is entered, but
anyone could unhide if the format/sheets/unhide toolbar is visible.
regards, Ditchy