Automatic Password Protect Sheet

L

Lorcan Dene

I've coded a button to open a file, copy some info from 1 sheet to another,
but i need the button to first unprotect the sheet, then do its copying, then
protect the sheet when finsihed.

i've tried:

Worksheets("Sheet1!").Protect (password)
and hence
WorkSheets("Sheet1!").UnProtect (password)

but it doesnt password protect it, only protects it normally, anyone help
please?
 
G

Gord Dibben

Sheets("Sheet1").Unprotect Password:="justme"

your code to do things

Sheets("Sheet1").Protect Password:="justme"


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to Store Passwords To Multiple Sheets and To Retain thatPasswords When the Workbook IS closed 1
Help with VB code 2
Copying in sheet with protection with the use of a macro 5
Copy data using macro (with worksheet protect) 5
"How do I un/protect sheet by macro program with password 5
<1000 2
Modifying a locked/protected sheet 3
Storing and Accessing Data 1

Top