Click here to Skip to main content
15,663,632 members
Articles / Programming Languages / Visual Basic
Posted 26 May 2006


28 bookmarked

Implementing Password Security on Excel Workbooks Using Visual Studio .NET

Rate me:
Please Sign up or sign in to vote.
3.92/5 (15 votes)
26 May 20061 min read
Creating password protected Excel workbooks using VB.NET.

Sample Image - Excel_Security.jpg


Developing secure products are as important as the product itself. Most security measures involve data encryption and passwords. Excel sheets are mostly used for reporting purposes and reports mostly based on confidential data, so security is very important for Excel based reports.

Here, I have tried to develop a small utility for a security implementation. The same code can be used in both Visual Studio 2003 and 2005, and the code can be implemented in C# with proper syntax changes.


Imports System.IO
Module Module1
    Public Filename As String
    Public oexcel As Excel.Application
    Public obook As Excel.Workbook
    Public osheet As Excel.Worksheet
    Sub Main()
            'File name and path, here i used abc file to be 
            'stored in Bin directory in the sloution directory
            Filename = AppDomain.CurrentDomain.BaseDirectory & _
            'check if file already exists then delete 
            'it to create a new file
            If File.Exists(Filename) Then
            End If
            If Not File.Exists(Filename) Then
                'create new excel application
                oexcel = CreateObject("Excel.Application")
                oexcel.Application.DisplayAlerts = False
                'add a new workbook
                obook = oexcel.Workbooks.Add
                oexcel.Visible = True

                Console.WriteLine("Generating Auto Report")
                osheet = oexcel.Worksheets(1)
                osheet.Name = "Test Sheet"
                osheet.Range("A1").Value = "Implementing " & _ 
                       "Password Security on Excel " & _ 
                       "Workbook Using Studio.Net"
                osheet.Range("A1").Font.Color = RGB(255, 255, 255)
                osheet.Range("A1").Interior.ColorIndex = 5
                osheet.Range("A1").Font.Bold = True

                'password variable and value
                Dim password As String = "abc"
                'if you are using excel 11 or above 
                'then use the following code
                obook.Password = password
                'otherwise use the folowing one
                obook.SaveAs(Filename, password:=password)
                'end application object and session
                osheet = Nothing
                obook = Nothing
                oexcel = Nothing
            End If
        Catch ex As Exception
        End Try
    End Sub
End Module

Working With the Demo

Download the demo project and unzip it, and then run "Excel_Automation.exe". It will generate an Excel sheet in the same directory with the name "abc.xls". When you try to open the Excel sheet, it will ask to enter the password, enter "abc", then the book will be visible to you.

Working With the Code

Here, I have attached the VB.NET code file, download it and then create a new console application project, and add the file to that project, and try with your desired changes. You can run the same code in both versions of Visual Studio .NET.


This is a small effort to generate a secure report for your critical data. Any feedback/comments are welcomed.


This article has no explicit license attached to it but may contain usage terms in the article text or the download files themselves. If in doubt please contact the author via the discussion board below.

A list of licenses authors might use can be found here

Written By
Program Manager ZonG, China Mobile Company
Pakistan Pakistan
I am working as Manager Enterprise Services where key responsibilities are to support end users on their day to day IT related issues.
The other function I am responsible is IT IPCC Services Support Since September 2013 and my key responsibilities are to maintain IPCC Uptime along with end users support at both CMPak call centers. IPCC enhancements and new feature development is also part of my job role.
The third area that was handed over to me in March 2015 is in-house apps support, where key responsibility is to provide support for all the application developed by IT department and to maintain the availability of these applications.
Previously I was working as Manager Automation & Planning and this is my key area of expertise. My responsibilities were to manage team in Project Planning, System Analysis, Requirements gathering, Preparation of SRS, Presentations to client about the requirements, getting Approvals on SRS from the Client, Database Design, Development Tracking, System Deployments, end user Feedback along with Change Management.

Planning and Defining Scope, Resource Planning, Time Estimating, Creating Charts and Schedules, Risk Analysis
Managing Risks and Issues, Monitoring and Reporting Progress, Team Leadership, Working with Vendors, Scalability were the key area of working along with an efficient problem-solver in professional way with envisions business and technical perspectives to develop workable solutions.

I started my career as developer in 2004 and promoted as team lead IT Automation in 2007 and then as manager so I spend 7 years in Software Development & Project Planning.

Comments and Discussions

Questionin c# Pin
Member 112520865-Jul-15 20:00
Member 112520865-Jul-15 20:00 
QuestionHow to do in VB.NET Pin
Jats_4ru4-Sep-07 22:31
Jats_4ru4-Sep-07 22:31 
AnswerRe: How to do in VB.NET Pin
jonesberyl17-Aug-10 21:58
jonesberyl17-Aug-10 21:58 
QuestionIs it standard Excel workbook protection? Pin
Bozhko Maxim23-Apr-07 1:28
Bozhko Maxim23-Apr-07 1:28 
QuestionWhat is ""? Pin
User 134930926-May-06 7:29
User 134930926-May-06 7:29 
AnswerRe: What is ""? Pin
Malik Nasir26-May-06 21:44
Malik Nasir26-May-06 21:44 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.