how to allow macro to write on a protected sheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

without using unprotect/protect way..
is there a way to allow program to write in certain ranges while users can't
write.

Thanks for all the help you provided.
MVM
 
Hi MVM,

If the UserInterfaceOnly argument is used with the protect method, tthe
worksheet can be manipulated with code.

The setting is not persistent between Excel sessions, so it is common
practice to set protection in the workbook open event.
 
You must log in or register to reply here.

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

Protecting worksheet. 1
VBA code to protect cells Outside a given range 2
Protection in code? 1
Spell Checking on a protected sheet 1
Running Macros in a Shared File 2
Macro can not unprotect a sheet in a shared workbook 4
"How do I un/protect sheet by macro program with password 5
Returned position address on protected sheet 7

Back
Top