List box problem

T

TUNGANA KURMA RAJU

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?
 
J

JMB

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.
 
Top