Thread: Macro location
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Macro location

How do you call the macros?

Did you place buttons (or other shapes) on the worksheet and then assign the
macro?

Did you attach a toolbar to the workbook that points at those macros?



Karen wrote:

I have a macro in a workbook that was emailed with 2 additional workbooks
that need to use this macro. There seems to be a problem when they save the
master as a new name. They still have to bring up last month's spreadsheet to
access the macro. What are the rules for macro location and how can I
simplify this process for my users? Can it also be because they make a new
folder for each period and save the renamed master in it?.
--
Excelsolutions4U


--

Dave Peterson