Whats the difference?

[Bob]

The difference in a macro attached to the tool bar as opposed to one
attached to the worksheet, Is it that if you made a copy and gave it to
someone else the macro would go with the sheet?
--
Thanks in advance for your help....Bob Vance
..
..
..
..

 

[JulieD]

Hi Bob

the way i understand it is - a toolbar is used to simplify the accessing of
the macros (an alternative to tools / macro / macros - click on macro -
press Run)

macros - recorded using tools / macro / record new macro - can basically
"live" in two places
a) personal macro workbook - which is a hidden workbook that opens up when
you start excel
b) on a module sheet within the workbook you're recording it in.

So if you go to record a macro (using above method) - you are presented with
the dialog box where you name the macro and also choose where to store it.
If you want the macro to be available to all your workbooks (ie it puts your
company name in cell A1) then store it in "personal macro workbook", if,
however it is only applicable to the specific workbook (makes range A1:E1 -
purple) then store it in the "This Workbook"

if you want to email the workbook to someone else then you need to store the
macro in "This Workbook" so that they have access.

hope this helps
Cheers
JulieD

 

[Bob]

Thanks Julie, think I will save them to worksheet as other people can have
the same macro that I have to operate the worksheet.

--
Thanks in advance for your help....Bob Vance
..
..
..
..