Hi Guru
I create a customize bar using VBA in excal 2000. it works fine. but when I use minimize or restore button in excal's window,not the minimize or restore button from "Worksheet menu Bar", the customize bar disappeared,and in my VBA code I turn off Formula bar and Status bar, but when I minimize window, these two Formula bar and Status bar show up, and trun off my Customize bar. I wouldn't like this happen. can anybody tell me how I can do about it?
many thanks in advance.
I create a customize bar using VBA in excal 2000. it works fine. but when I use minimize or restore button in excal's window,not the minimize or restore button from "Worksheet menu Bar", the customize bar disappeared,and in my VBA code I turn off Formula bar and Status bar, but when I minimize window, these two Formula bar and Status bar show up, and trun off my Customize bar. I wouldn't like this happen. can anybody tell me how I can do about it?
many thanks in advance.