Activate a macro from another sheet

[gibtoul]

Hello,

I have the following macro on feui2
I want to activate the macro cete sheet1

I added Sheets ("sheet1"). Select

but it does not work.

do you have an idea

Thank you for your help

Please Login or Register  to view this content.

[patel45]

attach please a sample file

[HaHoBe]

Hi, gibtoul,

we would like to help but:

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

Ciao,
Holger

[gibtoul]

Hello,

I attach the file.
I on Sheet2, the button to have an effect on the sheet1.

Thank you for your help

gibtoul

[patel45]

Insert a module and cut your code from Sheet1 and paste in module, then insert the line

Please Login or Register  to view this content.

although you have the button in sheet 2 the code must be in a module, then assign this code to desired button.

[gibtoul]

Thank you patel45