| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Best Way to protect sheet & workbook with VB
Help Please
I have certain cells locked and unlocked, and the locked cells cannot be selected when the sheet is protected. What is the best way to protect the sheet, but allow VB to run its code and place values into those cells that are locked? I tried .Unprotect and .Protect before and after each event, but it didnt prove to be very efficient and produced alot of errors. Thanks in advance, €” CDotWin |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Best Way to protect sheet & workbook with VB
Look at the userinterfaceonly argument to the protect method.
-- Regards, Tom Ogilvy "CDotWin" wrote in message ... Help Please I have certain cells locked and unlocked, and the locked cells cannot be selected when the sheet is protected. What is the best way to protect the sheet, but allow VB to run its code and place values into those cells that are locked? I tried .Unprotect and .Protect before and after each event, but it didnt prove to be very efficient and produced alot of errors. Thanks in advance, - CDotWin |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Protect WorkBook & Sheet | Excel Discussion (Misc queries) | |||
| Share Workbook/Protect Sheet Question | Excel Discussion (Misc queries) | |||
| Protect Workbook Vs Protect Sheet | New Users to Excel | |||
| Can I protect columns w/in a "List" using Protect Sheet? | Excel Discussion (Misc queries) | |||
| excel - macro code to open a protected sheet, enter passowrd, and then protect sheet | Excel Programming | |||
Hybrid Mode
