[Solved]On Click command button function

I'm trying to create a macro for a command button that when clicked, will get the job number from that row and look for a file for that job. If it does not exist I want it to copy from a template and save with a new name, otherwise just open the file.

However, I cannot seem to work out how to get hold of the information for the command button that calls the macro. This is what I have so far:

ShapeExists, checks if a button on that row exists, if not it creates one if a cell in that row has changed.

JobButton is what I am having problems with.

Please Login or Register  to view this content.

As you can see I am currently trying ActiveSheet.Shapes(Application.Caller).Select, this is causing a "Run-time error '13': Type mismatch".

Any help would be much appreciated, thank you!

In a test file your code works, until it tries to open template.

Where in your code does the error occur?
can you post example file to demonstrate the problem

The first issue was that the code you posted was not the code used in your example files.
The use of the ME object within a sheet object will refer to the sheet not the button that was just pressed.

This assigns the shape to a object variable for use within the code.

Please Login or Register  to view this content.

I do not get a 400 error. I do get a 1004 error if the current directory is not the one with the template file in it.

Adding the exact folder would help.

Please Login or Register  to view this content.

You can no simply step into and through the macro as the Application.Caller value will cause an error.
You can trap for that

Please Login or Register  to view this content.