Running a macro on all sheets in a file.

  • Thread starter Thread starter Eron
  • Start date Start date
E

Eron

Hi all,

Today I have a spreadsheet that contains 100 different sheets in it. In

my module I have to run a macro in each sheet in order to recieve the
final outcome.


Is there a way I could run one macro that will run on all the sheets at

once, instead of what I am doing today which is to log into each sheet
and run the macro.
 
sounds like you're working within Excel, not within Access. if so, suggest
you repost your question to an Excel newsgroup. macros in MS Access are very
different from macros in other Office software programs.
 
Back
Top