Hi there,

Please consider registering for an account. Registration is free, only takes a minute and will allow you to access members only boards. If you already have an account with us, then click here to log in.

collapse

* Who's Online

  • Dot Guests: 23
  • Dot Hidden: 0
  • Dot Users: 0

There aren't any users online.


Author Topic: Protect and unprotect a sheet. (VBA)  (Read 3913 times)

0 Members and 1 Guest are viewing this topic.

WestwegoManTopic starter

  • Administrator
  • Swamp Rat
  • *****
  • Posts: 50
  • Age: 51
  • Location: Westwego, La.
    • View Profile
Protect and unprotect a sheet. (VBA)
« on: Jan 23, 2015, 5:03 PM »
To protect using a macro:

Code: [Select]
Worksheets("Sheet1").Protect Password:=""Note: you can put a password in the parentheses.

To unprotect:

Code: [Select]
Worksheets("Sheet1").Unprotect Password:=""Note: you can put a password in the parentheses.


 


The postings on this site are my own and do not necessarily reflect the views of Jefferson Parish,

fellow employees, members of the public, suppliers or people working on behalf of the parish.


SimplePortal 2.3.6 © 2008-2014, SimplePortal