How to use alter worksheet protection

Alter worksheet protection is a file instruction under Excel Group that protect or unprotect the selected worksheet in an excel file.

Steps to Configure “Alter worksheet protection instruction

Protect worksheet

1. Open a process and turn on design mode

2. Load file manipulation step

3. Click on “Click here to select an instruction“, expand the excel group and select “Alter worksheet protection” instruction

4. Link an Excel file

5. Select a worksheet that you want to protect

6. Tick “Protect?” checkbox to protect the worksheet

7. Enter a password in the “New Password” field

8. Save and run the step

Fully configured Alter worksheet protection instruction to “protect worksheet” should look as shown below:

Un-protect worksheet

Alter worksheet protection instruction can also be used to un-protect worksheet. Below steps explain the steps to use unprotect the worksheet.

1. Follow steps 1 to 5 as mentioned in above steps.

2. Untick “Protect?” checkbox to unprotect the worksheet

3. Enter a password in the “Old Password” field

4. Save step details and Click on Run button

1 Comment
Leave a Reply

Latest Tweets

Free eBook: 10 Tips for sourcing good data yucalc.com/2017/02/17/fre…

reply · retweet · favorite

Newsletter

By signing up, you agree to our Terms of Service and Privacy Policy.

Address

Suite 1506, Westfield Tower 2, 101 Grafton St Bondi Junction NSW 2022 Australia

View Larger Map

Contact Us

AUS: +61-2-9386-0202
UK: +44-20-8123-1251
Send us an email

ContactUs.com
WordPress Image Lightbox