New to macros question

  • Thread starter Thread starter Rekoop
  • Start date Start date
R

Rekoop

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
 
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
 
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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Unwanted workbooks on startup 2
Macro for all Excel Workbooks to print to PDF 2
Macro shortcuts are running macros in different open workbook 3
How to Unlock Excel Workbook protected by MACRO Password 6
Macro to open file and copy information from worksheet 1
run macro in another workbook - error 1004 7
Remove Hyperlinks Without Changing background shading 14
Personal Macro Workbook 2

Back
Top