PDA

View Full Version : Sort in a Shared Workbook



spalomino
03-03-2010, 02:41 PM
I have created a protected shared workbook but cannot perform sort macro. Each sheet is protected in the workbook. When taking it out of shared sorting is fine using the code below:

ActiveSheet.Unprotect Password:="password"
ActiveSheet.protect Password:="password"

Is there something similar I can use for a protected shared workbook?

Thanks

Jan Karel Pieterse
03-04-2010, 01:04 AM
Activesheet.Protect Password:="password", UserInterfaceOnly:=True