View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
JTreks JTreks is offline
external usenet poster
 
Posts: 3
Default ShowAllData doesn't work with Protection

I have a macro attached to a button that is supposed to remove the filter by
using the command ShowAllData. As long as I don't protect the worksheet it
works fine. As soon as I turn on protection I get a VBA error. Any help here?