Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Locked Sheet
The easiest way I can think of is to unlock the sheet,
make the changes and lock it again. For example 1)Unprotect the sheet sheet1.unprotect, "password" 2)Change the formula Sheet1.Range("a1").FormulaR1C1 = "=RC[1]+RC[2]" 3)Re-protect the sheet sheet1.protect, "password" If you haven't already you could in future try "Userinterface :=true" which allows code to alter a sheet but prevents the user from doing so. hope this helps libby -----Original Message----- I want to write a VB Code that will change the formula in one cell on a locked sheet that is password protected? I know the password. It is a program that several people are using and I want to sent them an update to fix a glitch. However, I don't know the code to change a cell on a locked page?????? SDC . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Inserting a row into a locked sheet | Excel Discussion (Misc queries) | |||
locked out of my sheet for read only | Excel Worksheet Functions | |||
Sheet locked by user | Excel Discussion (Misc queries) | |||
locked up spread sheet | Excel Discussion (Misc queries) | |||
Excel file/Sheet Locked | Excel Discussion (Misc queries) |