Progress bar vba marco

VoG

Legend

Joined

Jun 19, 2002

Messages

63,650

• Jul 18, 2011

• #2

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

 

Upvote 0

B

Bradley H Callender

Board Regular

Joined

Aug 5, 2010

Messages

120

• Jul 18, 2011

• #3

great it works.

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

 

Upvote 0

VoG

Legend

Joined

Jun 19, 2002

Messages

63,650

• Jul 18, 2011

• #4

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

Code:

Private Sub Workbook_Open()
Call ShowDialog
End Sub

 

Upvote 0

B

Bradley H Callender

Board Regular

Joined

Aug 5, 2010

Messages

120

• Jul 22, 2011

• #5

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.

 

Upvote 0

VoG

Legend

Joined

Jun 19, 2002

Messages

63,650

• Jul 22, 2011

• #6

Try like this in the ThisWorkbook module

Code:

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

 

Upvote 0

B

Bradley H Callender

Board Regular

Joined

Aug 5, 2010

Messages

120

• Jul 22, 2011

• #7

Thanks

 

Upvote 0