Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11
Default Combo Box Drop down & Sheet Protection

Hi All,

Thanks in advance for any help you can give me.

I've got a spreadsheet that we're using to enter in timesheet
information. Some columns are unlocked and some (with formulas that I
don't want touched) are locked. I have a combobox that is activated
when a user double clicks or uses Ctrl + Shift + Z, and it is designed
to show with the dropdown menu already activated. The Combo box is
linked to a cell that is not protected, although it displays (due to
it's size) above cellse that are protected.

However, when I protect the sheet and trigger the combo box, it
displays with the dropdown up, and no amount of clicking on the
dropdown arrow will trigger the dropdown either.

What further confounds me is that if I take protection of the sheet
off, it doesn't fix the issue. If I resave without protection and open
again, still the same problem.

Any ideas?

Thanks,

Dave

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel Data Protection Best Practice: AKA: Real Sheet Protection Mushman(Woof!)[_2_] Excel Discussion (Misc queries) 4 December 30th 09 01:20 AM
Excel Data Protection- AKA: Sheet/Macro Password Protection Mushman(Woof!) Setting up and Configuration of Excel 0 December 29th 09 06:50 AM
Combo box drop down & worksheet protection DocEE Excel Discussion (Misc queries) 0 September 21st 06 02:30 PM
combo box protection jimmy g Excel Discussion (Misc queries) 0 August 10th 06 07:23 PM
Combo boxes and Protection [email protected] Excel Discussion (Misc queries) 0 June 27th 05 03:40 PM


All times are GMT +1. The time now is 11:40 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"