CHANGE PROTECTED CELL VIA MACRO

  • Thread starter Thread starter SUNIL
  • Start date Start date
S

SUNIL

Hi

Is it possible to change cell A1 from a macro if sheet and cell are
protected?

Response will be much appreciated.
Thanks
 
SUNIL said:
*Hi

Is it possible to change cell A1 from a macro if sheet and cell are
protected?

Response will be much appreciated.
Thanks *
Click to expand...

Possible if you know the password.
You can unprotect worksheet and cell via macro.

Why don't you use "UserInterfaceOnly" when you protect the worksheet?
;)
 
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

OnTime Change_Event macro AND copy to sheet2 macro trouble 7
Run two macros for two different sheets 11
VBA set thick borders around non empty cells in range 0
quick way to prohibit all editing/changes to workbook (2010) 2
Remove Hyperlinks Without Changing background shading 14
Clearing data from Excel 2003 Form 1
Certain string in cell A1 causes a change in Cell B1 7
How can I protect cell from user entry but able to alter/clear in 2

Back
Top