Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
The Requirement:
I am trying to protect a sheet and some cells that I do not want thee regular users to write in but need to write to those cells with VBA code. The Problem: I can sometimes write to those cells with VBA without having to unprotect the sheet first but some times (or on other PC's) the code fails to write to the same cells. I can adjust the code to always unprotect but wonder why it works sometimes and not other? Can someone please provide some insight! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Merging cells in a Protected Sheet | Excel Worksheet Functions | |||
Merge Cells on Protected Sheet | Excel Discussion (Misc queries) | |||
Edit text format in non-protected cells in protected worksheet | Excel Discussion (Misc queries) | |||
Why can't I merge cells in a protected sheet? | Excel Programming | |||
How do I unprotect certain cells in a protected sheet? | Excel Worksheet Functions |