Home

FREE Signup

Advertise

Link to Us

Help

Excel Tutorial: Protect/Unprotect excel sheet using macro

jawahar
5/23/2007 4:56:26 PM, Views: 2746

The following tutorial shows how to protect/unprotect the excel sheet using macro

You have to pass the excel sheet name to the following functions to protect/unprotect the sheet

Code to fetch the sheet name:

ThisWorkbook.ActiveSheet.Name

Code to unprotect sheet

Public Sub Unprotect_Sheet(sname)
Sheets(sname).Unprotect Password:="password"
End Sub

Code to protect sheet

Public Sub Protect_Sheet(sname)
Sheets(sname).Protect Password:="password"
End Sub

Next Steps:

Add this Tutorial to:
	Blink	Del.icio.us	Digg
	Fark	Furl	Google
	Reddit	Simpy	Spurl
	Technorati	Win Live	Yahoo

Rate Me!

Avg Visitor Rating: Average Visitor Rating is 4 out of 5

Number of Ratings : 3 Votes

Send Message

Signup / Login To View the Solution or Provide Comments

Post Comment/Solution

Comment:*
	(Link Rules)
	Use : [bold] for <b>; [/bold] for </b>; [italic] for <i>; [/italic] for </i>; [code] & [/code] for code

Most Popular Solution

1. Protecting Excel Fil...

Top Rated

1. Excel Worksheet Prot...

2. Protecting Excel Fil...

3. Finding the sheet na...

4. Excel BAHTTEXT Funct...

5. Read values and form...

6. Protect/Unprotect ex...

7. Finding unique value...

8. Automatically Wrap c...

9. MS Excel Jet OLEDB C...

Top Rankers

Overall

1. jawahar (450)

Yearly -2008

1. jawahar (50)

Expertsforge Sponsors

1. Recover deleted files

FREE Signup div

Advertise

Link to Us div

Sitemap

Tutorial Sitemap div

About Us