| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
activesheet.tab.colorindex not working when workbook shared
I have a workbook with the following code operating correctly in exclusive access. However, this code fails with an error 1004 when the workbook is put into shared mode. This will fail for a single cell named as "PassFail"
Any thoughts? For Each C In Range("PassFail") If C.Value = "Fail" Then ActiveSheet.Tab.ColorIndex = 3 ElseIf C.Value = "Pass" Then ActiveSheet.Tab.ColorIndex = 4 End If Next c Last edited by Martin Appleton : July 21st 06 at 09:51 AM |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Inserting Comments In A Shared Workbook | Excel Discussion (Misc queries) | |||
| Shared Workbook | Excel Discussion (Misc queries) | |||
| Shared Workbook Protection | Excel Discussion (Misc queries) | |||
| How can I get a validation to run in a macro on a shared workbook? | Excel Discussion (Misc queries) | |||
| how to limit edit access to certain users for a shared workbook? | Excel Worksheet Functions | |||
Linear Mode
