rename macro

[AnnPhil]

is there a way to have the rename macro prompt the user for the name?

thanks in advance

 

[Mile-O]

Create a new module and put these lines of code:

Function GetTableName() As String
     
     GetTableName = InputBox("What do you want to call this new table?", "Renaming Table")

End Function

Now, in your macro, where it says: New Name, put:- =GetTableName()


That should do what you want.

Ideally, you'd get more functionality and error handling (macros don't even have this capability) by using forms and code to do what you wish.

Try converting the macro to VBA to get the code and see how the structure works.

 

[AnnPhil]

Thanks very much, it worked great!!!!!