hide sheets while running a macro

M

mbdevent

Hi,

I made a workbook with some sheets, on the first sheet, the user ca
fill in a form and then execute a macro. The macro uses informatio
from other sheets. I don't want the user to see the use of the sheet
(espacially the changing of sheets is very annoying for the user). Doe
anyone know a script to add in to the macro so the user won't see th
other sheets?

Thanks,
Matth
 
A

Andy Wiggins

Application.ScreenUpdating = False
'' Code here
Application.ScreenUpdating = True

--
Regards
Andy Wiggins
www.BygSoftware.com
Home of "Save and BackUp",
"The Excel Auditor" and "Byg Tools for VBA"
 
Top