Originally Posted by SamT I am coming to the conclusion that the VBA Compiler does not always interpret 0 and <> 0 as False and True. I had no such problem on my computer. I agree. I saw nothing wrong but had to make the change for the code to run. @ Jason It might be useful to build in a password over-ride if you need to see admin views on a user's PC.
MVP (Excel 2008-2010) Post a workbook with sample data and layout if you want a quicker solution. To help indent your macros try Smart Indent Please remember to mark threads 'Solved'
Forum Rules