Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a worksheet (Order) that has Range A13:B90 unlocked and the sheet is
protected. I use a macro to force cursor movement left to right for Item# & Qty, then cursor advances to next row in column A. Col A = Item # and Col B = Qty. User can input a valid item number (checked in macro). However, I have a "0" (zero) as a generic item number that a user can enter. After entering a qty for a zero item number, I have an inputbox pop up to ask for an item description. Normally the item description is inserted automatically in D13:D90 via a formula. This range is protected. Question, using DIM ItemDesc As String" with this variable holding the value input via inputbox, how do I insert this value into the cell. I have the code to do it if the sheet is not protected, but I want the sheet to remain protected. Thanks, Les |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Protected WorkSheets | Excel Discussion (Misc queries) | |||
Groups and Protected Worksheets - know if protected | Excel Discussion (Misc queries) | |||
Protected worksheets | Excel Discussion (Misc queries) | |||
Group, Outline, Protected Worksheets and Protected Workbook | Excel Programming | |||
Protected Worksheets | Excel Programming |