Hiding sheets yet still can work on them

markwoodrow

New Member
Joined
Oct 4, 2006
Messages
1
Hello experts!

I have a VB macro to copy / paste and manipulate worksheet data yet I want to visually hide from the user the screen hopping from one worksheet to another. I use the Visible method to hide, yet disallows any work on the sheet...unless my inexperience is hindering me. I'm too new and inexperienced to go further. Can you help?

Thanks
Mark
 

Some videos you may like

Excel Facts

Will the fill handle fill 1, 2, 3?
Yes! Type 1 in a cell. Hold down Ctrl while you drag the fill handle.

Pyromantic

Board Regular
Joined
Aug 9, 2006
Messages
58
How About:

Code:
Sub Macro()
    Application.ScreenUpdating = False
    ...
    Your code here...
    ....
    Application.ScreenUpdating = True
End Sub

Screenupdating stops the user seeing what is happening to the workbook while the macro is running. And it speeds up the macro.
 

Watch MrExcel Video

Forum statistics

Threads
1,108,960
Messages
5,525,911
Members
409,671
Latest member
nasseralateek

This Week's Hot Topics

Top