lock a cell from users but not macros

  • Thread starter Thread starter Miree
  • Start date Start date
M

Miree

I have a work sheet my macro copys data into. When i just protect the sheet
the macro will not run. Is there a way to lock it so the macro will still
work but the users can not edit the data.

Thank you
 
Hi

Unprotect the sheet at the top of the macro and then re-protect at the end.

Regards,
Per
 
Is there a way to get this to work with a password? when i tried to do it
with password it needed a user input, to unprotect, i dont want my users to
have the password. Also it doesn't lock with a pass word
 
Try this

ActiveSheet.Unprotect Password:="MyPass"
' do things
ActiveSheet.Protect Password:="MyPass"

Mike
 
Use this syntax:

ActiveWorkbook.Unprotect Password:="JustMe"
ActiveWorkbook.Protect Password:="JustMe"

Regards,
Per
 

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

Run Macro If Cell have "x" value 0
Macro to Combine Data from Multiple Sheets with Cell References 4
Run macro from active workbook whose name keeps changing 20
Pasting cell contents into a macro 1
OnTime Change_Event macro AND copy to sheet2 macro trouble 7
Protect worksheet cells but still allow macro to edit chartproperties 2
Running Macros in a Shared File 2
Run Macro on All Sheets Q 8

Back
Top