answersLogoWhite

0

One way would be to prompt the user to choose a workbook from those currently open (or browse for one that isn't). However, an easier approach is to simply run the macro on the currently active workbook by assigning the macro to a toolbar button.

User Avatar

Wiki User

9y ago

What else can I help you with?

Related Questions

How do you create an external reference to a cell into another workbook in excel?

You need to enclose the workbook name in square brackets, then specify the sheet in that workbook and then the particular cell. So if you wanted to refer to cell A10 on Sheet2 of a workbook called Sales.xls then the reference would be like this: =[Sales.xls]Sheet2!A10


When you create formulas in one workbook that reference cells in a different workbook you are doing what?

You are linking the two workbooks.


When a workbook is saved as a template by default it is saved to?

create new folder


What is a special workbook or worksheet you can create and then use as a pattern to create new similar workbooks or worksheets?

A template.


How can you create a macro in Excel that saves the day's income in a workbook and then creates a new workbook every week?

how am i surpose to no?? go on the internet and find out for your self !!


How many pivot table can be can be created in the Excel?

You can create as many as you need. However, you are unlikely to need to create many in a workbook.


What might you do if you were organizing by location?

create a description that moves from one space to another space.


How do you create a macro to open another workbook automatically?

It can be done easily by addingWorksbooks.open Filename:=command in macro.Eg: Workbooks.Open Filename:= _"C:\Documents and Settings\abcabc\My Documents\Company List.xls"If you like to create a particular macro for this purpose, the following lines will be helpful for youSub OpenWorkbook()'' OpenWorkbook Macro' To Open Another workbook automatically''Workbooks.Open Filename:= _"C:\Documents and Settings\ABABC\My Documents\Company List.xls"End SubHope this will solve your issueBalu


If you chose to create a description that moves from one space to another space you would be organizing by?

location


What is a partially completed workbook that you can use to create other workbooks that have the same structure and purpose?

template


Can Christians teleport from one location to another?

Yes, they absolutely can. The power of Jesus can create all things.


What is a background formula checking in Excel?

Excel continually reviews the workbook for errors in formulas as you create or manipulate it