Time Delay

Mechanic · May 9th, 2002, 10:23 AM

I have a "Word Art" image I would like to show in a spreadsheet while a macro is running. I have:

ActiveSheet("logo").Visible=True
at the beginning of the macro, and:

ActiveSheet("logo").Visible=False
at the end of the macro. However the macro runs so fast you never see the logo. What simple code can I put in to slow or suspend execution for a couple of seconds so the macro has time to appear and the user to comprehend it?

Mechanic

Nimrod · May 9th, 2002, 10:38 AM

Just a thought but maybe you could put the logo.false in a sheet action section, such as the Sheet.change procedure.

i.e.
Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range
ActiveSheet("logo").Visible=False
end sub

May 9th, 2002, 10:38 AM	#2
Nimrod MrExcel MVP Join Date: Apr 2002 Location: Vancouver BC , Canada Posts: 6,259	Just a thought but maybe you could put the logo.false in a sheet action section, such as the Sheet.change procedure. i.e. Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range ActiveSheet("logo").Visible=False end sub __________________ <MARQUEE>...........Never be afraid to try something new. Remember, amateurs built the ark, professionals built the Titanic...............The easiest thing to find is fault, don't be easy !.. --Anonymous--...</marquee>

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 9th, 2002, 10:23 AM	#1
Mechanic Board Regular Join Date: Mar 2002 Posts: 60	I have a "Word Art" image I would like to show in a spreadsheet while a macro is running. I have: ActiveSheet("logo").Visible=True at the beginning of the macro, and: ActiveSheet("logo").Visible=False at the end of the macro. However the macro runs so fast you never see the logo. What simple code can I put in to slow or suspend execution for a couple of seconds so the macro has time to appear and the user to comprehend it? Mechanic