A macro button opens a document it was recorded on.

[Levi22]

Hi guys

I have assigned a Macro to a Button. I run a Macro to copy all worksheets to a new book before i start working on it.
The Macro that i run also closes the Origianal book and only leaves the copy open.

Now, there is a Macro Button in the original document. The button copies correctly to the new book but when I click on it, it opens the original book, and I don't want it to do that.

Can anyone please help.

Regards,

Nyiko

 

[Redwolfx]

Depending on how you name the new file, if you are copying ALL worksheets to a new file, and you want the button to do the same thing it does in the original file, couldn't you accomplish this by just doing a SaveAS in your Macro?

 

[Norie]

Nyiko

Assign the macro in the copied workbook to the button.

 

[Levi22]

Hi Red

I have other books which are linked to the original book and I am still a Newby when it comes to Macros and I don't want to mess the Macro that i already have.

I thought maybe there was a way around it.

 

[Levi22]

Norie.

That would work if i was the only one using the original. I am creating a costing tool for my department. A copy of the original is created whenever there is new project. So i am not the one workin on it.

 

[Norie]

Why not add code to do it?

 

[Levi22]

hi Norie.

I have used 'ActiveX Controls' instead of 'Form controls' to add my code, and that solved my problem.

Now I can copy all sheets and the copied Button doesn't open the original book anymore.

Thank you.