How to call a macro in another sheet

**torgn** · 02-20-2017, 11:01 AM

I have three sheets (sheet1, sheet2 and sheet3). I have registered a macro on sheet 1 that adds a column and converts seconds to minutes. In sheet 2 I have created a macro that filters data in a table and should copy data to sheet3. I want to create a macro that calls theese macros to execute and do what they were intended to do by creating a figure in sheet 3 and relate it to this "master macro" . How can I do that?

I have tried, without any success.

Please Login or Register  to view this content.

**jeffreybrown** · 02-20-2017, 11:10 AM

Your code looks fine for a Call.

Have you tried to step thru the code to see what is happening?

**torgn** · 02-20-2017, 11:22 AM

Yes, The Macros runs on sheet 3, Nothing happens in sheet 1 or 2

**jeffreybrown** · 02-20-2017, 11:42 AM

Can you provide the workbook with the code!

**torgn** · 02-20-2017, 12:58 PM

This examplefile should illustrate my problem.

**Norie** · 02-20-2017, 01:07 PM

As they are written the code in the subs will run against the currently active sheet.

What is the first sub meant to do?

Which sheets do you actually want the code to run against?

**jeffreybrown** · 02-20-2017, 01:12 PM

I don't quite understand the Call copy_text_to_sheet3 and what you are tying to accomplish.

As for the Convert, try...

Please Login or Register  to view this content.

**torgn** · 02-20-2017, 01:43 PM

Originally Posted by jeffreybrown

I don't quite understand the Call copy_text_to_sheet3 and what you are tying to accomplish.

My problem is that I can`t publish the sheet I am working on. It contains info I don`t want to be public. Since I have severeal sheets (many more than 3 acutally in the original document), and macros running on the different pages, I want to find a methode beeing able to run all the macros with just one push on a button without having to step into each and one sheet to run one macro at a time.

**torgn** · 02-20-2017, 01:50 PM

What does this line do?

Please Login or Register  to view this content.

**jeffreybrown** · 02-20-2017, 01:58 PM

Originally Posted by torgn

I want to find a method being able to run all the macros with just one push on a button without having to step into each and one sheet to run one macro at a time.

And that you can do! You just need to qualify the sheets so the macro knows what sheets to get the data from.

**jeffreybrown** · 02-20-2017, 01:59 PM

It copies the formula to:

Please Login or Register  to view this content.

Does this small example help!

**torgn** · 02-21-2017, 05:40 AM

Originally Posted by jeffreybrown

I don't quite understand the Call copy_text_to_sheet3 and what you are tying to accomplish.

As for the Convert, try...

Please Login or Register  to view this content.

This seems to fit my purpose, but how do I add a new column to the c column?

**jeffreybrown** · 02-21-2017, 08:42 AM

Originally Posted by torgn

This seems to fit my purpose, but how do I add a new column to the c column?

I'm not exactly sure what you mean by add a new column! Can you give some contest please?

**torgn** · 02-21-2017, 09:45 AM

What I was trying to say

Have The following columns:
Network Address, Remote Site, Duration (sec),Duration,Call Direction,Call Type

I have created a macro with help from you for converting values and send the output to next column.

Please Login or Register  to view this content.

Before I can run this code/Macro I have to create an empty column next to Duration (sec) to place the output from the Convert_hours_to_minutes Macro. The clue is stil that I don`t wan`t to switch between sheets everytime I want to run a macro, but just one button to push that execute all (or most of) my macros on different sheets.

**Logit** · 02-21-2017, 02:09 PM

A..... It appears you want a new colum after Column D. This macro creates a new column to the left of Column E
which accomplishes your goal.

Please Login or Register  to view this content.

B..... Not certain where you want the new macro above that creates a new blank column.

C..... I changed the macro for copy / paste from Ark2. It works now.

D..... Your macro (below) functions well as is. Simply place the calls to the various macros in the order you want them executed.

As it is right now, the macros are executing in this order:

#1 copy_text_to-sheet3
#2 Convert_hours_to-minutes.

If this order is ok, then simply add the next macro call below - or - rearrange the order.

E.....

Please Login or Register  to view this content.

How to call a macro in another sheet

LinkBack

Thread Tools

Rate This Thread

Display

How to call a macro in another sheet

Re: How to call a macro in another sheet

Re: How to call a macro in another sheet

Re: How to call a macro in another sheet

Re: How to call a macro in another sheet

Re: How to call a macro in another sheet

Re: How to call a macro in another sheet

Re: How to call a macro in another sheet

Re: How to call a macro in another sheet

Re: How to call a macro in another sheet

Re: How to call a macro in another sheet

Re: How to call a macro in another sheet

Re: How to call a macro in another sheet

Re: How to call a macro in another sheet

Re: How to call a macro in another sheet

Thread Information

Users Browsing this Thread

Similar Threads

hw we call a private macro in other sheet from module1

[SOLVED] How to call a click button which is on another spread sheet in your MACRO

How to call a sheet-specific macro

Call sub for another sheet + when sheets name is string in sheet

[SOLVED] Macro to call data from a specified file in the sheet

Call macro (Sheet 1) from any change in sheet 2

Set cell focus based on list, call macro from sheet

Macro to call sheet number instead of name

Bookmarks

Bookmarks

Posting Permissions