View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default how do I make a simple macro

Macros are stored in workbooks. You can create it and export it to a bas
file, but to run it, it must be in a workbook.

--
Regards,
Tom Ogilvy

"mike" wrote in message
...
I'd like to create a simple macro that I can give to other
people and that they can load and assign to a button. How
do I do that without creating a project? Or do I have to
create a project? The macro I have in mind consists of
just a few lines I need to automate a couple of processes,
nothing fancy.

mike