View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Greg Lovern Greg Lovern is offline
external usenet poster
 
Posts: 224
Default ProgressBar control in 64-bit Excel


Hi Jim,

Try a test of the Win32 compiler constant...

#If Win32 then
* * *'use progress bar
#Else
* * 'use statusbar ?
#End If


I'm using compiler constants for other purposes, especially standard
DLLs. But for the ProgressBar control, the error occurs when opening
the workbook, because it's a reference in the Controls toolbox.
Conditional compiling doesn't help with references.

Is it possible to use the ProgressBar control without a reference?

Greg