[SOLVED] Create button to save cell data to workbook header

Hi John,

I don't seem to be able to use either code within the

Please Login or Register  to view this content.

Coding, any suggestions?

The second suggestion worked for me?

Please Login or Register  to view this content.

You have to make a selection before clicking.

Hi John,

Still no joy, I created a new button and input the following,

Please Login or Register  to view this content.

I made a cell selection and clicked on the Button3 but got the following error message,

"Cannot run the macro "Machine Reportstest.xlsm'!Customer_Info_Button3_Click'. The macro may not be available in this workbook or all macros may be disabled."

Macros are definitely enabled as my other buttons work ok.

Any ideas?

Cheers

Tony

Originally Posted by JOHN H. DAVIS

The second suggestion worked for me?

Please Login or Register  to view this content.

You have to make a selection before clicking.

Can you attach a sample workbook? To attach a file, push the button with the paperclip (or scroll down to the Manage Attachments button), browse to the required file, and then push the Upload button.

Originally Posted by JOHN H. DAVIS

Can you attach a sample workbook? To attach a file, push the button with the paperclip (or scroll down to the Manage Attachments button), browse to the required file, and then push the Upload button.

Hi John,

Workbook attached, I have removed the button, which I had placed alongside the entry cell for the customer name and also the vba module.

Cheers

Tony

Tony:

Try this

Please Login or Register  to view this content.

Hi John,

I have no idea what is going on, still the same message as before, all other buttons work fine. Very odd.

I tested it on the file you attached? It worked fine. Maybe someone else may have some ideas?

Hi John,

I have attached the workbook again, this time with button and code, can you see if it works on your system please?

Regards

Tony

I sorted out the error as being previousaly experienced however I am now getting a mismatch error on

Please Login or Register  to view this content.

I am using a text string in the cell,

Please Login or Register  to view this content.

should be correct, so any ideas why the "Runtime error 13, type mismatch"?

Machine Reportstest.xlsm

Tony:

I added a command button to Column Q. If you select a cell and click it you'll see that it addeds a Center Header based on the selection to all worksheets. Isn't that what you're trying to achieve?

Hi John,

Yes I eventually figured out where I was going wrong, so it is all sorted now. Many thanks

Took us awhile, but we got there. Glad to hear you've got a working solution.