Excel 2000 - How to access hidden cell formula when protected with UserInterfaceOnly ?

  • Thread starter Thread starter Lionel Gomes
  • Start date Start date
L

Lionel Gomes

Hi Guys,

This one should be simple for you guys!

In Excel 2000, I have cells that are protected (Locked and Hidden).
When I protect the sheet I use the UserInterfaceOnly option of the
protect function.
However I could not access the cell.formula even by code when the sheet
is protected.

Is this a normal behavior? And if so, Is there any workaround other than
unprotected the sheet?

Thanks,
Lionel
 
If you want to view the formula but protect the cell, do not check the
"Hidden" checkbox when formatting the cell for protection. Be sure the
"Locked" checkbox is checked (default).
 
Back
Top