阅读背景:

保护Excel工作表的格式和大小,仅允许输入

来源:互联网 

I am creating an XLS worksheet that would be used to collect data from the users. I have restricted the user input using validations. In order to easily be able to print the worksheet i have set the lenghts of the columns. Have made the relevant columns wrap. However i would like to protect the worksheet such that User is not allowed to 1. Change the format 2. Change the Validations 3. Change the column size User should be allowed to 1. Enter input values 2. Select the value (from drop down whereever applicable)I am creating an XLS worksheet that would be us




你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到: