#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,069
Default COMBO Box

Hi

I use protectiong sheet in excel and I would like to use combo box. once use
protection sheet I could able to open combo box (drag down).

Pls help me to advice

Thanks

JOHN
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default COMBO Box

Does your combobox have a linked cell?

Is that linked cell locked (and on a protected worksheet)?

If yes, then unlock that linked cell.

John wrote:

Hi

I use protectiong sheet in excel and I would like to use combo box. once use
protection sheet I could able to open combo box (drag down).

Pls help me to advice

Thanks

JOHN


--

Dave Peterson
  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,069
Default COMBO Box

Hi Dave

Thank you so much, the problem is solve !!!

many thanks

JOHN

"Dave Peterson" wrote:

Does your combobox have a linked cell?

Is that linked cell locked (and on a protected worksheet)?

If yes, then unlock that linked cell.

John wrote:

Hi

I use protectiong sheet in excel and I would like to use combo box. once use
protection sheet I could able to open combo box (drag down).

Pls help me to advice

Thanks

JOHN


--

Dave Peterson

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
Best way to populate worksheet from 2 combo boxes jswasson Excel Worksheet Functions 0 July 7th 06 01:21 PM
Macro that can run combo boxes simonsmith Excel Discussion (Misc queries) 0 June 5th 06 05:00 PM
Nesting Combo Boxes /Returning an Array ELMONDO SNITHER Excel Discussion (Misc queries) 1 June 30th 05 01:15 AM
connecting combo boxes to yield data in another cell. TxN8tv Excel Discussion (Misc queries) 0 March 14th 05 04:07 PM
dynamic combo boxes tjb Excel Worksheet Functions 2 January 25th 05 07:33 PM


All times are GMT +1. The time now is 07:13 AM.

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"