Run sort macro with sheet protected

[Andrewrx]

Hi,

I have created two buttons which sort data within a spreadsheet.
But when I protect the sheet to prevent changes to data these macro's cannot run because the sort option is disabled.

Is there a way to get around this?

many thanks
Andrew

 

[Andrew Poulsom]

You will need to unprotect the sheet:

ActiveSheet.Unprotect

then protect it again afterwards:

ActiveSheet.Protect

Both methods accept arguments. Record a macro while you unprotect and protect to see the full syntax.

 

[Andrewrx]

excellent!

thanks for the quick reply

 

[DonkeyOte]

You may want to put the password in also so as to not to be propted...

eg Sheets("Sheet1").unprotect password:="password"

and to reset....

Sheets("sheet1").protect password:="password"