VBA Ads

Monday, May 25, 2009

Ignore Task Bar Shaking While Opening a WorkBook in VBA

If you are a VBA programmer then you could come across the following problem.

If your macro opens and closes the workbooks multiple times, then you can see annoying behavior happens in the Taskbar (i.e) like shaking action in Task bar take place.

In order to ignore this annoying behavior (Shaking) in windows task bar, you have to include the following line before the macro process starts or before opening a workbook.
Application.ShowWindowsInTaskbar = false

At the end of macro process you can set this value to true (original state).
Application.ShowWindowsInTaskbar = True

Hope this tips will be useful.

No comments: