View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
FredL FredL is offline
external usenet poster
 
Posts: 17
Default User controlled Freeze Pane while protected

Hi,

I have a worksheet where it is protected and locked.
Is there anyway to code there such that the user (who cannot unlock the
sheet) can still use the freeze pane function so that they can determine how
to view the worksheet? I know you can enable the grouping via macro (e.g.
..EnableOutlining) while it is protected. Can the same be done for freeze
pane?

Thanks,
Fred