ActiveX Progress bar initialization in Excel 2003 problem

G

Guest

I setup a Microsoft ActiveX Progress Bar version 6 on a worksheet. I preset
the values in a command button click procedure. Everytime I open the excel
work book for the first time the Progress Bar is set to some other distorted
property value which in turn makes my Progress bar look distorted. The only
way it adhere's to the settings I placed in the code is when I Ctrl Break
inthe middle of the execution. I shtere a way to overide this initialization
blunder?
 
G

Guest

If you have not tried it yet, go into design mode on your excel sheet and
right-click on the progress bar control - you should be able to set the
properties there. Set them the way you want them to appear on opening and
then resave the worksheet.

If changes are being made to the properties as you use the workbook and
these are being saved, you may want to reset the important properties in
either your Workbook_Open or Workbook_BeforeSave event procedures.
 
G

Guest

Ihave tried doing what you suggested but somehow when I close the work book
and reopen the Progress bar seems to be getting it's own properties setting
from somewhere which overides what i have set in workbook open or anyplace
else. It adheres to my settings only after Ctrl Break and I execute the
command. If you want I can email you a copy so you can see it for your self
kind of hard to explain.
 
G

Guest

Hey I found out what the problem was it was a simple repaint of the
worksheet where the activex Progress bar resided in. When it appear distorted
by accident i scrolled the worksheet down far enough for the activex
disappear and scroll back up for it to appear and the activex progressbar to
its rightful properties. To compensate I activated cells far down enough to
scroll down and then activated A1 cell in the open event of the workbook. I
wonder does this have something to do with my screen resolution or setting?

Thanks all for your suggestions and help.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top