LinkBack URL
About LinkBacks
Do files with Macros have to keep the same filename?
If they do, that makes sense. I've seen myself get confuzzled when if I Save As>different name.
Do files with Macros have to keep the same filename?
If they do, that makes sense. I've seen myself get confuzzled when if I Save As>different name.
If the macros are held in the workbook in question, (as opposed to being held in the separate and often hidden Personal.xlsm) workbook, then the file can be saved and renamed however you want. It will still retain the macros.
Not sure why you should encounter any problems when saving as a different name. You do need to save the workbook as a .xlsm file. Maybe that's the problem and that you have been saving as just a .xlsx workbook.
If not can you give a bit more clarification? i.e. exactly what are you doing and what are you calling the files.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
I'll try. When I try and open a file, I get this, click "Update", then untitled2. THe file opens and when I try and use a Macro I "wrote" earlier (does not claim to speak VB natively), I get untitled 3.
File itself is uploaded for convenience. I'm lost :-(
Please explain what you are trying to do with your workbook.
It contains one 'FillName macro of any note and it's not clear at all what this is attempting to do.
The Search button on sheet1 is also attached to a macro in another named workbook which may be the source of your problems, particularly if it refers to a file name that you have subsequently renamed or moved elsewhere.
I'm attempting to make a search box where you type your name into the box; and hit the button on the right to search. Names are listed in column A.
Would it be easier if I just root out the button and put in a new one? Or I can reassign the Macro by Right click, Link to a Macro?
Hi,
Just reassign the macro to which the button is directed to a macro in the current workbook.
I'm not entirely sure why you need a text box. Why not just enter a name in a cell. If you want to select a name from a drop down use data validation with a named list.
What is supposed to happen when you click the button?
It's supposed to search for the name you've entered. I'll mark solved meanwhile.
Do you mean that the file is supposed to be automatically saved with the name shown by the character string that appears in the box/cell?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks