Home |
Search |
Today's Posts |
#1
|
|||
|
|||
New BUG in Excel 2010?
I have found what I believe to be a bug. I have researched it extensively but have found nothing. I apologize if I missed something. This is what I've got.
Excel 2010 in Windows 7. 1. Open New workbook 2. Select entire sheet, right click and clear checks from Format Cells\Protection tab. 3. Select any column, check "locked" on Protection tab. (use "L" for this example) 4. Select and HIDE columns M, N and O. 5. Protect sheet. 6. Select column L thru P (in order to unhide) 7. Right click At this point, Excel locks up and requires closure of the program to regain control. This happens on every pc that I have tried it on. It appears to be right clicking on a locked column in a protected worksheet is the issue. Anyone seen this before? Any info would be helpful. Many thanks. Wayne |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
New BUG in Excel 2010?
Whays brought next idea :
I have found what I believe to be a bug. I have researched it extensively but have found nothing. I apologize if I missed something. This is what I've got. Excel 2010 in Windows 7. 1. Open New workbook 2. Select entire sheet, right click and clear checks from Format Cells\Protection tab. 3. Select any column, check "locked" on Protection tab. (use "L" for this example) 4. Select and HIDE columns M, N and O. 5. Protect sheet. 6. Select column L thru P (in order to unhide) 7. Right click At this point, Excel locks up and requires closure of the program to regain control. This happens on every pc that I have tried it on. It appears to be right clicking on a locked column in a protected worksheet is the issue. Anyone seen this before? Any info would be helpful. Many thanks. Wayne You can't hide/unhide cols/rows on a protected sheet via the UI. If you want to be able to do this via the UI then 'Group' the cols/rows and allow outlining when you set protection. Otherwise you'll need to unprotect before you hide/unhide rows/cols! Alternatively, you could use a macro to do this on the locked sheet. If you set the protection parameter 'UserInterfaceOnly:=True' then your macro won't have to toggle protection. (Note that this parameter does not persist between sessions, and so must be reset when the workbook is opened) -- Garry Free usenet access at http://www.eternal-september.org ClassicVB Users Regroup! comp.lang.basic.visual.misc microsoft.public.vb.general.discussion |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
32 bit DLL with 64 bit Excel 2010 | Excel Programming | |||
Excel 2010 | Excel Discussion (Misc queries) | |||
Form 4 Range of time from 1/20/2010 4:00 AM To 1/21/2010 10:00 AM | Excel Worksheet Functions | |||
Can't open workbook in excel 64 bit 2010 - but can in excel 2010 3 | Excel Programming |