Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
New to macros question
What is the difference between storing a recorded macro in
i. New Workbook or ii. This workbook? I understand that storing a recorded macro in the Personal Macro Workbook will make the macro available to all Excel workbooks; I just do not know the difference between the first two is. Thanks in advance |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
New to macros question
Not positive, but i believe that if you store it in New Workbook, i
will open a new blank workbook and store the macro there. If you sav it in This Workbook, it will save on the workbook in which you recor the Macro. Please correct me if i'm wrong here -- Message posted from http://www.ExcelForum.com |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
New to macros question
ThisWorkbook is the workbook that is active when you start to record the
macro. New Workbook is as it says, a new workbook. You would need to save either before quitting Excel or the macros are lost. -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Rekoop" wrote in message ... What is the difference between storing a recorded macro in i. New Workbook or ii. This workbook? I understand that storing a recorded macro in the Personal Macro Workbook will make the macro available to all Excel workbooks; I just do not know the difference between the first two is. Thanks in advance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
macros vba question | Excel Worksheet Functions | |||
Question on Macros | Excel Discussion (Misc queries) | |||
Question about macros. | Excel Discussion (Misc queries) | |||
question macros | Excel Worksheet Functions | |||
A question regarding Macros | Excel Programming |