View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Pluggie Pluggie is offline
external usenet poster
 
Posts: 23
Default Macro that uses three hidden sheets

I have a .xls with 4 sheets.
The first is visible, the other three are hidden.
I start a series of macro's from the visible sheet.

These Macro's:
- Import data from two external documents and paste this in the hidden sheets.
- Use and modify data on the three hidden sheets.
- Export from one of the hidden sheets to a new document.
- Delete contents of the three hidden sheets.
- Save the document
- Close the document.

Well now... at the moment... the 3 sheets are not hidden. The macro's run
fine.
But I am continuously bothered by the fact that I see everything the macro's
do flash through the screen.
I would much rather have the macro run, seeing only a blank screen with an
hourglass or something.

The thought is to run the macro's with the sheets hidden... but perhaps
there's another way? I tried hiding the sheets, but I get errors when I do.

Any Ideas?