#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 171
Default List box problem

I have inserted a listbox in a w/book,this w/book has no macros.Whenever I am
opening this w/book a message box 'this w/book contains macros
enable,disable'
is poping up.As I know my w/book has no macros,I opted for 'disable
macros'.But after that I am unable to select an item from the list in my
listbox.Cusor becoming cross arrows(4arrows) style.How to resolve this?
  #2   Report Post  
Posted to microsoft.public.excel.misc
JMB JMB is offline
external usenet poster
 
Posts: 2,062
Default List box problem

Per Excel help file:

"If you disable the macros, you won't be able to run any macros, recalculate
custom functions, run event handlers (macros that run in response to actions
such as mouse clicks), or use ActiveX controls to initiate events."

ActiveX controls include list boxes.


"TUNGANA KURMA RAJU" wrote:

I have inserted a listbox in a w/book,this w/book has no macros.Whenever I am
opening this w/book a message box 'this w/book contains macros
enable,disable'
is poping up.As I know my w/book has no macros,I opted for 'disable
macros'.But after that I am unable to select an item from the list in my
listbox.Cusor becoming cross arrows(4arrows) style.How to resolve this?

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
auto updating list Larry Excel Worksheet Functions 8 July 27th 06 01:59 PM
Excel 2003 - XML List Formatting Problem Niko Excel Discussion (Misc queries) 0 June 8th 06 12:32 PM
update data validation list with new entries?? cjtj4700 Excel Discussion (Misc queries) 10 December 12th 05 01:00 AM
Filtered list & maximum no columns problem claytorm Excel Discussion (Misc queries) 0 August 24th 05 10:52 AM
Update master list with other lists Chab Excel Worksheet Functions 0 August 4th 05 03:46 PM


All times are GMT +1. The time now is 08:23 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"