View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Damian Damian is offline
external usenet poster
 
Posts: 71
Default Sheet Protection

I wrote a Micro to change something is DataValidation window with a shortcut
key ctrl-F. When I protect the sheet I am unable to use that micro.
I even tried allowing all the functions that are listed in protection window
and still nothing.

Is there a way to get pass that? Or is DataValidation just LOCKED when you
protect the sheet.

Thanks