计算机与现代化 ›› 2013, Vol. 1 ›› Issue (9): 229-231,.doi: 10.3969/j.issn.1006-2475.2013.09.056

• 应用与开发 • 上一篇    下一篇

用VBA程序保护Excel文件

李 花,郭建璞   

  1. 中国传媒大学计算机与网络中心,北京 100024
  • 收稿日期:2013-03-22 修回日期:1900-01-01 出版日期:2013-09-17 发布日期:2013-09-17

Protecting Excel Files by Using VBA Program

LI Hua, GUO Jian-pu   

  1. Computer and Network Center, Communication University of China, Beijing 100024, China
  • Received:2013-03-22 Revised:1900-01-01 Online:2013-09-17 Published:2013-09-17

摘要: 针对Excel文件的版权和内容保护问题,使用VBA程序代码,结合Excel软件自身的保护功能,从技术上提供较为实用的解决方案。该方案用VBA程序在原始文件中添加用户身份信息,并禁止其他用户拷贝文件内容,但不影响文件的正常使用。用VBA程序保护Excel文件的方法,也可以应用到Office的其他文档中。

关键词: 拷贝, 原始文件, Office, 版权

Abstract: For the problem of copyright and content protection of Excel documents, using VBA code, combining with the protective function of Excel, a more practical solution is provided from a technical point. In this scheme, user identity information is added to the original file with VBA program, and the file contents copy is forbidden. But the normal use of the file is not affected. The protection method for Excel file with VBA program can be also applied to other Office documents.

Key words: copy, original file, Office, copyright

中图分类号: