| Home |
| Search |
| Today's Posts |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Allow users to edit ranges for VBA objects
Problem solved!
The "cell link" in VB objects will return value to certain cells. I right clicked those cells, selected "format cells", under "Protection" tab, UNCHECKED the "Locked" checkbox. Then I can protect the worksheet, and change the VB objects! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| "Allow users to edit range." Office 03 vs. 97... | Excel Discussion (Misc queries) | |||
| Allow users to edit range query | Excel Discussion (Misc queries) | |||
| Protected Cell | Excel Worksheet Functions | |||
| Protecting Workbook | Excel Discussion (Misc queries) | |||
| Multiple excel users can open the same file and edit at the same . | Excel Discussion (Misc queries) | |||
Threaded Mode
