View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
FARAZ QURESHI FARAZ QURESHI is offline
external usenet poster
 
Posts: 553
Default How to unprotect a workbook by macro?

THANX PAL!
I REALLY APPRECIATE!
CAN U ALSO NOTIFY ME SOME CODE RESTRICTING INSERTION/DELETION, OR CHANGING
SIZE OF, ANY COLUMN/ROW?
THANX AGAIN!

"JLatham" wrote:

Oops - you said workBOOK, not workSHEET.

Use ActiveWorkbook.Unprotect instead of Worksheets('sheetname').Unprotect




"FARAZ QURESHI" wrote:

HELP! HELP! HELP!
I have a workbook with its structure locked. How to unprotect a workbook by
macro?