在复制和粘贴时隐藏工作表 [英] Hiding Worksheet while copying and pasting

问题描述

我正在开发一些Excel VBA例程，从一张表中获取数据，生成其他工作簿，然后在它们之间复制各种表格和数据。

我做了很多

有没有一种简单的方式来隐藏每个人，直到结束，并显示某种进度条？

我不想隐藏/显示的东西，当我需要复制/粘贴他们...我希望excel做一切静默的背景。

任何方式这样做？

解决方案

您可以暂时禁用 ScreenUpdating

  Sub SilentRunning（）
 Application.ScreenUpdating = False 
'
'东西
'
 Application.ScreenUpdating = True 
 End Sub 
  

I am developing some Excel VBA routines that take data from one sheet, generate other workbooks, then copy various sheets and data between them.

I am doing a lot of switching between workbooks/sheets back and forth.

is there a simple way to hide everyting until the end and show some sort of progress bar?

I somply don't want to hide/show things when I need to copy/paste them...I would like excel to do everything silently in background.

Any way to do this??

解决方案

You can temporarily disable ScreenUpdating

Sub SilentRunning()
    Application.ScreenUpdating = False
    '
    '   do your thing
    '
    Application.ScreenUpdating = True
End Sub

这篇关于在复制和粘贴时隐藏工作表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！