Progress bar vba marco

[Bradley H Callender]

What is the marco code i would need to make a progress on a userform work?

 

[VoG]

Here's an example http://spreadsheetpage.com/index.php/tip/displaying_a_progress_indicator/

 

[Bradley H Callender]

great it works.

Another question, how do i gett his to open whent he page starts up?

 

[VoG]

If you mean that you want it to run as soon as you open the file, in the ThisWorkbook module

Private Sub Workbook_Open()
Call ShowDialog
End Sub

 

[Bradley H Callender]

Hi i need a macro code that would allow to do the follow:

when i try to close the workbook with the "X" it prevents me switches to a different sheet, saves the whole work book then close.

 

[VoG]

Try like this in the ThisWorkbook module

Private Sub Workbook_BeforeClose(Cancel As Boolean)
Sheets(1).Select
Me.Save
End Sub

 

[Bradley H Callender]

Thanks