Protect/UnProtect Excel workbook using password

 Follow this steps 

Open your excel file --> Go to File --> Info --> Protect workbook --> Select Encrypt with Password --> Enter password to protect your sheet. 


You can also protect your sheet as read only in same Menu so your file will be open as read only.


To remove password or UnProtect your workbook you need to follow the same steps and remove/empty the password 

Comments

Post a Comment

Popular posts from this blog

WCS Command Context initialization and cloning.

Command context will contain information regarding command object, You can retrieve user, store, language related information from command. The command context is set to the controller command when the command is invoked by the component facade. The command context should be used as a read-only object. You should not call its setter methods. Example to get Command context: private CommandContext getCommandContext() {         CommandContext commandContext = null;         ActivityToken activityToken = ((BusinessContextInternalService) BusinessContextServiceFactory                 .getBusinessContextService()).getActivityToken();         commandContext = ContextHelper.createCommandContext(activityToken );         return commandContext;     } Cloning Command Context: if you want to change any object value in command context then always recommended t...
Read more

HCL Commerce v9 Installation steps

Download the HCL Commerce eAssemblies :  All current versions of  HCL Commerce   and   HCL Commerce Developer   can be downloaded from   HCL License and Delivery portal . Setting up HCL Commerce development environment : https://help.hcltechsw.com/commerce/9.0.0/install/concepts/cigdenvinstalldeploy.html Download Installation Manager and install  https://www.ibm.com/support/fixcentral/swg/selectFixes?parent=ibm%7ERational&product=ibm/Rational/IBM+Installation+Manager&release=1.9.1.2&platform=Windows&function=all&useReleaseAsTarget=true ** Please create directory where you want to install all your version 9 packages before starting installation manager install.  Ex:  mkdir C:\IBM Download RAD, WAS, DB2 and Commerce packages, Follow below URLs for details Installing RAD : https://help.hcltechsw.com/commerce/9.0.0/install/tasks/tiginstallrad.html Installig WAS : https://help.hcltechsw.com/commerce/9.0.0/install/ta...
Read more