P
Pluggie
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?
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?