View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ed Adamthwaite Ed Adamthwaite is offline
external usenet poster
 
Posts: 1
Default Application.DisplayFormulaBar Kills CutCopyMode

Hi all,
I have a friend with workbook that he needs to distribute and doesn't want
to have the formula bar visible to users.
When using Application.DisplayFormulaBar = False/True when switching between
sheets or workbooks, the CutCopyMode is deactivated.

Is there any way preserve the CutCopymode while doing other Events within
the Excel app?

Thanks for any replies,
Ed.