View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
notso notso is offline
external usenet poster
 
Posts: 24
Default hide columns/rows/cells on open

I want to automatically hide columns when the user opens a password protected
sheet or workbook. The users with the passwords sometimes leave the hidden
columns in unhidden when they save and close. How do I make sure that hidden
columns etc. are automatically hidden on all sheets when the workbook is
opened.