adspace


Some of the functions that we want our macros to accomplish are not possible without first unprotecting the worksheet/workbook with the password?

Answer Posted / Mayank Singh

To perform functions on a protected Excel workbook or worksheet, you must first unprotect it by using the 'Unprotect Sheet' or 'Unprotect Workbook' command. You will need to know the correct password for the protection level you wish to remove. It is important to note that unprotecting a workbook can be risky if shared with others, so make sure to only remove protections when necessary.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is wrap text in excel?

720


Why can't I see the tabs on my excel spreadsheet?

723


Image result for how do I compare two columns in excel

667


What is left formula in excel?

683


How much is excel for ipad?

713


Which is latest version of excel?

721