| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Error desipite UserInterfaceOnly in protection - Why?
I have protected the sheet with " UserInterfaceOnly:=True" and still, I
get - Sometimes! - error onfollowing line: If ActiveSheet.Range("D2:M2").SpecialCells(xlCellType Visible).Cells.Count < _ Sheet2.Range("Years").Value Then I don't know why, I get error and if I run the worksheet_activate event again, it passes without a problem. Please advice, this leavs me without a clue. Under what circumstances doesn't "UserInterfaceOnly" cover events? Regards, tskogstrom |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| UserInterfaceOnly & Password Protection | Excel Discussion (Misc queries) | |||
| protection using UserInterfaceOnly | Excel Programming | |||
| Excel 2003 Userinterfaceonly Password Protection Problem | Excel Programming | |||
| question about worksheet protection using userinterfaceonly:=true | Excel Programming | |||
| Protection UserInterfaceOnly reading Hidden Formulas | Excel Programming | |||
Hybrid Mode
