Doing a sorting out on a locked sheet.

[VBASHA]

Could you please tell me how to sort out values while my excel sheet is blocked. When I click on my push button for sorting out, it results in an error.

Thanks in advance.

Shameem

 

[xlbo]

Can't sort whilst the sheet is protected
Presumably, you have some code attached to a button that does the sort...
before the sort code have the line
activesheet.unprotect password:="password"
and after the sort code
activesheet.protect password:="password"

obviously, change "password" to whatever the sheet's password is...

Rgds
Geoff
"Some cause happiness wherever they go; others whenever they go."
-Oscar Wilde

 

[ajcarr]

There is also an additional parameter to Protect
"UserInterfaceOnly:=True" which prevents the user changing the worksheet but allows it to be changed by macros. It is reset when the file is loaded so you need to put it in the Autpen macro if you want it implemented each time the workbook is loaded.