ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   List box problem (https://www.excelbanter.com/excel-discussion-misc-queries/111927-list-box-problem.html)

TUNGANA KURMA RAJU

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?

JMB

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?



All times are GMT +1. The time now is 01:34 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com