Thread: autosorting protected data with macros
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
dr chuck dr chuck is offline
external usenet poster
  
Posts: 74
Default autosorting protected data with macros
thanks gord
--
dr chuck


"Gord Dibben" wrote:

Yes. That would be another method.

Sub Do_Stuff()
ActiveSheet.Unprotect Password:="justme"

'your code here

ActiveSheet.Protect Password:="justme"
End Sub


Gord


On Mon, 19 Jun 2006 08:12:02 -0700, dr chuck
wrote:

thanks will check it out....
Wonder if i had my macro turn off the protection when it filtered and then
turn it back on after filter if that would resolve my data protection issues?


Reply With QuoteReply With Quote